Re: Remove xmin and cmin from frozen tuples

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)