Re: Determining when a row was inserted - Mailing list pgsql-general

From Greg Stark
Subject Re: Determining when a row was inserted
Date
Msg-id 878y1rdot8.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Determining when a row was inserted  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Matt Miller
Date:
Subject: Re: Autonomous Transactions
Next
From: Scott Marlowe
Date:
Subject: Re: Autonomous Transactions