Re: New feature request: FlashBack Query

From: Theo Schlossnagle <jesus(at)omniti(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Theo Schlossnagle <jesus(at)omniti(dot)com>, RPK <rohitprakash123(at)indiatimes(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: New feature request: FlashBack Query
Date: 2007-02-20 18:45:52
Message-ID: E7B42318-DDE3-480A-9AAB-586D90FD2C5C@omniti.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Feb 20, 2007, at 1:40 PM, Tom Lane wrote:

> RPK <rohitprakash123(at)indiatimes(dot)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/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2007-02-20 19:01:03 Re: autovacuum next steps
Previous Message Tom Lane 2007-02-20 18:40:36 Re: New feature request: FlashBack Query