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

From Tom Lane
Subject Re: CREATE TABLE, load and freezing
Date
Msg-id 21282.1204256724@sss.pgh.pa.us
Whole thread Raw
In response to CREATE TABLE, load and freezing  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Responses Re: CREATE TABLE, load and freezing
List pgsql-hackers
"Pavan Deolasee" <pavan.deolasee@gmail.com> writes:
> In a typical scenario, user might create a table and load data in the
> table as part of a single transaction (e.g pg_restore). In this case,
> it would help if we create the tuples in the *frozen* state to avoid
> any wrap-around related issues with the table.

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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Batch update of indexes on data loading
Next
From: Tom Lane
Date:
Subject: Re: UUID data format 4x-4x-4x-4x-4x-4x-4x-4x