Skip site navigation (1) Skip section navigation (2)

RE: WAL feature

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 (view raw or flat)
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?



In response to

pgsql-hackers by date

Next:From: Mikheev, VadimDate: 2001-04-28 00:41:43
Subject: RE: WAL feature
Previous:From: Mikheev, VadimDate: 2001-04-28 00:20:14
Subject: RE: WAL feature

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group