RE: Re: TODO list

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: Re: TODO list
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A234D3388@sectorbase1.sectorbase.com
обсуждение исходный текст
Ответ на TODO list  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
> > Blocks that have recently been written, but failed to make
> > it down to the disk platter intact, should be restorable from
> > the WAL log.  So we do not need a block-level CRC to guard
> > against partial writes.
> 
> If a block is missing some sectors in the middle, how would you know
> to reconstruct it from the WAL, without a block CRC telling you that
> the block is corrupt?

On recovery we unconditionally copy *entire* block content from the log
for each block modified since last checkpoint. And we do not write new
checkpoint record (ie do not advance recovery start point) untill we know
that all data blocks are flushed on disk (including blocks modified before
checkpointer started).

Vadim


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

Предыдущее
От: Philip Warner
Дата:
Сообщение: Re: Re: TODO list
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: TODO list