On Thu, Sep 01, 2005 at 09:20:48AM -0700, Josh Berkus wrote:
> > What I'm saying is that you can write a heap file, on which the tuples
> > would all have xmin=FrozenTransactionId, xmax=Invalid, and the
> > corresponding bits set in the infomask. This ensures that no matter the
> > state of the server, you can plug the file in and all tuples will be
> > valid.
>
> So, bulk loading by file generation? So the idea is that you would generate
> a properly formatted PostgreSQL table file, and then in one transaction
> create the table and attach it?
Exactly.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"Changing the world ... one keyboard at a time!"
(www.DVzine.org)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
