Re: New feature request: FlashBack Query - Mailing list pgsql-hackers

From Theo Schlossnagle
Subject Re: New feature request: FlashBack Query
Date
Msg-id E7B42318-DDE3-480A-9AAB-586D90FD2C5C@omniti.com
Whole thread Raw
In response to Re: New feature request: FlashBack Query  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: New feature request: FlashBack Query  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-hackers
On Feb 20, 2007, at 1:40 PM, Tom Lane wrote:

> RPK <rohitprakash123@indiatimes.com> writes:
>> I did not mean asking for undo from a life-time log. Since FlashBack
>> Technology is already there, I just mean that world's most  
>> advanced database
>> (PostgreSQL, as they say), must have an optimized way for undoing  
>> of at
>> least a week changes.
>
> You're living in a dream world.  Do you know any Oracle DBs who keep
> enough rollback segments to go back a week?

Ours go for a good 6 hours sometimes :-D

// Theo Schlossnagle
// Esoteric Curio: http://www.lethargy.org/~jesus/



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: New feature request: FlashBack Query
Next
From: "Jim C. Nasby"
Date:
Subject: Re: autovacuum next steps