RE: WAL & SHM principles

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: WAL & SHM principles
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A234D32FE@sectorbase1.sectorbase.com
обсуждение исходный текст
Ответ на WAL & SHM principles  (Martin Devera <devik@cdi.cz>)
Ответы RE: WAL & SHM principles  (Martin Devera <devik@cdi.cz>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: Proposed WAL changes
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Performance monitor