RE: WAL & SHM principles

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Martin Devera'" <devik(at)cdi(dot)cz>, pgsql-hackers(at)postgresql(dot)org
Subject: RE: WAL & SHM principles
Date: 2001-03-08 03:34:03
Message-ID: 8F4C99C66D04D4118F580090272A7A234D32FE@sectorbase1.sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> 1) WAL
> We have buffer manager, ok. So why not to use WAL as part of
> it and don't log INSERT/UPDATE/DELETE xlog records but directly
> changes into buffer pages ? When someone dirties page it has to
> inform bmgr about dirty region and bmgr would formulate xlog record.
> The record could be for example fixed bitmap where each bit corresponds
> to part of page (of size pgsize/no-of-bits) which was changed. These
> changed regions follows. Multiple writes (by multiple backends) can be
> coalesced together as long as their transactions overlaps and there is
> enough memory to keep changed buffer pages in memory.
>
> Pros: upper layers can think thet buffers are always safe/logged and
> there is no special handling for indices; very simple/fast redo
> Cons: can't implement undo - but in non-overwriting is not needed (?)

But needed if we want to get rid of vacuum and have savepoints.

Vadim

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-03-08 03:34:39 Re: Performance monitor
Previous Message Karl DeBisschop 2001-03-08 03:32:48 Re: Performance monitor