Re: WAL & SHM principles

Поиск
Список
Период
Сортировка
От Kevin T. Manley \(Home\)
Тема Re: WAL & SHM principles
Дата
Msg-id 986a4v$2u6l$1@news.tht.net
обсуждение исходный текст
Ответ на RE: WAL & SHM principles  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Список pgsql-hackers
""Mikheev, Vadim"" <vmikheev@SECTORBASE.COM> wrote in message
news:8F4C99C66D04D4118F580090272A7A234D32FA@sectorbase1.sectorbase.com...
> > It is possible to build a logging system so that you mostly don't care
> > when the data blocks get written; a particular data block on disk is
> > considered garbage until the next checkpoint, so that you
>
> How to know if a particular data page was modified if there is no
> log record for that modification?
> (Ie how to know where is garbage? -:))
>

You could store a log sequence number in the data page header that indicates
the log address of the last log record that was applied to the page. This is
described in Bernstein and Newcomer's book (sec 8.5 operation logging).
Sorry if I'm misunderstanding the question. Back to lurking mode...







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

Предыдущее
От: Kovacs Zoltan
Дата:
Сообщение: Re: pg_dump writes SEQUENCEs twice with -a
Следующее
От: Denis Perchine
Дата:
Сообщение: Re: Performance monitor