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