Re: CREATE TABLE, load and freezing

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CREATE TABLE, load and freezing
Дата
Msg-id 21282.1204256724@sss.pgh.pa.us
обсуждение исходный текст
Ответ на CREATE TABLE, load and freezing  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Ответы Re: CREATE TABLE, load and freezing  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Batch update of indexes on data loading
Следующее
От: Tom Lane
Дата:
Сообщение: Re: UUID data format 4x-4x-4x-4x-4x-4x-4x-4x