Re: CREATE TABLE, load and freezing - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: CREATE TABLE, load and freezing
Date
Msg-id 2e78013d0802282006w69f8f032y1a1af3b376ec4aec@mail.gmail.com
Whole thread Raw
In response to Re: CREATE TABLE, load and freezing  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Feb 29, 2008 at 9:15 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>
>  We've heard that idea before, and it's just as bad as it was when
>  proposed before.  "Pre-frozen" tuples eliminate any possibility of
>  tracking when a tuple was inserted; which is extremely important to know
>  when you are trying to do forensic analysis of a broken table.  The
>  point of the current design is to not throw away information about tuple
>  insertion time until the tuple is old enough that the info is (probably)
>  not interesting anymore.
>

Understood. But if we consider a special case of creation and loading
of a table in a single transaction, we can possibly save the information
that the table was loaded with pre-frozen tuples with xmin equals to the
transaction creating the table.
Thanks,
Pavan


-- 
Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: OSSP can be used in the windows environment now!
Next
From: Tom Lane
Date:
Subject: Re: Silly Newbie question