Re: [HACKERS] wal_checksum = on (default) | off

Поиск
Список
Период
Сортировка
От Florian Weimer
Тема Re: [HACKERS] wal_checksum = on (default) | off
Дата
Msg-id 87k602v4xj.fsf@mid.deneb.enyo.de
обсуждение исходный текст
Ответ на Re: [HACKERS] wal_checksum = on (default) | off  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] wal_checksum = on (default) | off  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
* Tom Lane:

> I think short burst errors are fairly likely: the kind of scenario I'm
> worried about is a wild store corrupting a word of a WAL entry while
> it's waiting around to be written in the WAL buffers.

Ah, does this mean that each WAL entry gets its own checksum?  In this
case, Adler32 is indeed suboptimal because it doesn't use the full 32
bits for short inputs.  It might still catch many wild stores, but the
statistics are worse than for CRC32.

(I had assumed that PostgreSQLs WAL checksumming was justified by the
partial write issue.  The wild store could easily occur with a heap
page, too, and AFAIK, tuples, aren't checksummed.  Which would be an
interesting option, I guess.)

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

Предыдущее
От: "Gurjeet Singh"
Дата:
Сообщение: Re: [HACKERS] [Fwd: Index Advisor]
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] wal_checksum = on (default) | off