| 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: | Whole Thread | Raw Message | 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 |