> > > 	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.

How to re-use freed space (ie how to maintain information about
blocks available for insertion of new rows) is another issue,
of course, but anyway - space must be freed first.

Vadim

Fri, 27 Apr 2001 17:20:14 -0700
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
RE: WAL feature
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?



Fri, 27 Apr 2001 21:41:28 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
RE: WAL feature