No, pageflows are not DB persistent. They use jPDL to express the flow of pages, but do not persist state in the database. Pageflows persist state within conversations (in fact you cannot initiate a pageflow outside of a conversation).
The numberguess example contained in the Seam distribution demonstrates the use of pageflows. The dvdstore example demonstrates jBPM processes (persistent processes, not pageflows).