Re: [HACKERS] An introduction and a plea ... - Mailing list pgsql-hackers

From Chris Bitmead
Subject Re: [HACKERS] An introduction and a plea ...
Date
Msg-id 389E1E8F.DBDDEDE3@nimrod.itg.telecom.com.au
Whole thread Raw
In response to An introduction and a plea ...  (Emmanuel Charpentier <charpent@bacbuc.dyndns.org>)
List pgsql-hackers
Hannu Krosing wrote:

> > >     The same kind of file could be used for re_introducing time-travel in an
> > >     efficient way.
> >
> > How?
> 
> By writing (TID,TIMESTAMP) tuples there and using that info to retrieve tuples
> active at specified time by examinimg TIDs in "deleted" tuples.
> As bot TID and TIMESTAMP should be monotonuously growing again binary search
> can be used on retrieve and inserts are append-only (meaning fast)

But since we are already storing all the time travel stuff already in
the
storage pages do we need this to reinstate time travel? Also if you
reinstate
time travel this way it will only work for people using this odbms
feature.
Wouldn't it be better to reinstate the old timetravel so it works for
everyone?


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] An introduction and a plea ...
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Case sensitivity issues