Re: tablelog - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: tablelog
Date
Msg-id 200902111119.25383.dfontaine@hi-media.com
Whole thread Raw
In response to Re: tablelog  (Bruno Lavoie <bruno.lavoie@gmail.com>)
List pgsql-general
Hi,

On Tuesday 10 February 2009 17:36:38 Bruno Lavoie wrote:
> Oracle Flashback Query seems to use undo logs to return in a point in
> time if the undo retention param permit it. You can do it with a date,
> or with the SCN (system change number), a kind of transaction number. It
> saves you administration task and table management, and *space*.
>
> Is this doable with PG, using some pg transaction logs?

It's been discussed recently:
  http://archives.postgresql.org/pgsql-hackers/2009-02/msg00117.php

No idea how this would compare to the timetravel contrib, though, only that
the mail refers to concepts yet to be proposed and implemented etc...

Regards,
--
dim

Attachment

pgsql-general by date:

Previous
From: Igor Katson
Date:
Subject: Making a result of transaction visible to everyone, saving the ability for a rollback
Next
From: Serge Fonville
Date:
Subject: PostgreSQL clustering with DRBD