Re: Determining when a row was inserted

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Determining when a row was inserted
Дата
Msg-id 878y1rdot8.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Determining when a row was inserted  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> As it happens, the original Berkeley-era Postgres did indeed add
> creation and deletion timestamps to every row, as part of their "time
> travel" feature.  That got ripped out very soon after the code left
> Berkeley, because the overhead was just unacceptable ... and our
> threshold for unacceptable performance was a whole lot higher then
> than it is today ...
>
> It's worth noting in connection with this Joe Hellerstein's description
> of Berkeley-era Postgres:
> http://archives.postgresql.org/pgsql-hackers/2002-06/msg00085.php

The followups are fascinating too. The next three messages immediately begin
discussing how to get back this feature at least as an option.


--
greg

В списке pgsql-general по дате отправления:

Предыдущее
От: Matt Miller
Дата:
Сообщение: Re: Autonomous Transactions
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Autonomous Transactions