Re: Regarding redo/undo files.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Mamta Singh <mamta_csd(at)yahoo(dot)co(dot)in>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Regarding redo/undo files.
Date: 2004-08-08 01:53:21
Message-ID: 4629.1091930001@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
> On Fri, Jul 30, 2004 at 05:53:02AM +0100, Mamta Singh wrote:
>> I went thru the site
>> http://www.postgresql.org/docs/7.4/static/wal-benefits-later.html

> I see that most of this document is obsolete.

Yeah, I was planning to remove that section or at least edit it
severely...

> I'm pretty sure there's people that don't want UNDO to be implemented.

I think the general consensus is that it doesn't offer us anything we
need, and the downsides are significant. (Oracle DBAs are well aware
of the hazards of having to rely on the transaction log for UNDO ---
it does not play well at all with long-running transactions.)

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-08-08 02:08:51 beta time
Previous Message Joe Conway 2004-08-08 01:52:21 Re: Postgres development model (was Re: CVS comment)