Re: Page Checksums

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Page Checksums
Дата
Msg-id 20111219141821.GB24234@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Page Checksums  (Aidan Van Dyk <aidan@highrise.ca>)
Ответы Re: Page Checksums  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
* Aidan Van Dyk (aidan@highrise.ca) wrote:
> #) Anybody investigated putting the CRC in a relation fork, but not
> right in the data block?  If the CRC contains a timestamp, and is WAL
> logged before the write, at least on reading a block with a wrong
> checksum, if a warning is emitted, the timestamp could be looked at by
> whoever is reading the warning and know tht the block was written
> shortly before the crash $X $PERIODS ago....

I do like the idea of putting the CRC info in a relation fork, if it can
be made to work decently, as we might be able to then support it on a
per-relation basis, and maybe even avoid the on-disk format change..

Of course, I'm sure there's all kinds of problems with that approach,
but it might be worth some thinking about.
Thanks,
    Stephen

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Page Checksums
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Command Triggers