From: | George(dot)T(dot)Essig(at)stls(dot)frb(dot)org |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Table Timemachine! |
Date: | 2002-12-18 19:16:58 |
Message-ID: | 20021218192552.E20DA476D2F@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
There is a presentation about journaling databases available at:
http://conferences.oreillynet.com/cs/os2002/view/e_sess/2551
The basic idea is that with database journaling you can extract
a snapshot of the data at any past date. At the time of the talk,
the speaker said he was going to make the code public. I don't know
if this was ever done.
George Essig
> I've been asked by a colleague about methods to keep track of
> 'previous' contents of a table - i.e. changes made and a way of
> getting back to a previous state.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2002-12-18 19:23:55 | Re: ORDER BY random() LIMIT 1 slowness |
Previous Message | Jean-Luc Lachance | 2002-12-18 19:09:42 | Re: ORDER BY random() LIMIT 1 slowness |