From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
Cc: | "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | RE: WAL feature |
Date: | 2001-04-28 00:41:28 |
Message-ID: | Pine.BSF.4.33.0104272140370.452-100000@mobile.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Mikheev, Vadim | 2001-04-28 00:41:43 | RE: WAL feature |
Previous Message | Mikheev, Vadim | 2001-04-28 00:20:14 | RE: WAL feature |