RE: WAL feature - Mailing list pgsql-hackers

From The Hermit Hacker
Subject RE: WAL feature
Date
Msg-id Pine.BSF.4.33.0104272140370.452-100000@mobile.hub.org
Whole thread Raw
In response to RE: WAL feature  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
On Fri, 27 Apr 2001, Mikheev, Vadim wrote:

> > > >     Row reuse without vacuum
> > >
> > > Yes, it will help to remove uncommitted rows.
> >
> > Same question as I asked Bruce ... how? :)  I wasn't trying to be
> > fascisious(sp?) when I asked, I didn't realize the two were
> > connected and am curious as to how :)
>
> After implementing UNDO operation (we have only REDO now)
> transactions will roll back their changes on abort and so
> free space occupied by inserted rows.

Ahhh, okay, so this isn't reusing space on delete/update, so much as
avoiding writing to the table until the transaction is committed?




pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: v7.1.1 branched and released on Tuesday ...
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: WAL feature