Re: AdvanceXLInsertBuffer vs. WAL segment compressibility

Поиск
Список
Период
Сортировка
От Chapman Flack
Тема Re: AdvanceXLInsertBuffer vs. WAL segment compressibility
Дата
Msg-id 886a3377-9f2d-2176-15f7-b9ac1eb4dce7@anastigmatix.net
обсуждение исходный текст
Ответ на Re: AdvanceXLInsertBuffer vs. WAL segment compressibility  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On 08/02/2016 02:33 PM, Bruce Momjian wrote:

> My guess is that the bytes are there to detect problems where
> a 512-byte disk sector is zeroed by a disk failure.

Does that seem plausible? (a) there is only one such header for
every 16 512-byte disk sectors, so it only affords a 6% chance of
detecting a zeroed sector, and (b) the header contains other
non-zero values in fields other than xlp_pageaddr, so the use
of a fixed value for _that field_ in zeroed tail blocks would
not prevent (or even reduce the 6% probability of) detecting
a sector zeroed by a defect.

-Chap



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: TODO item: Implement Boyer-Moore searching in LIKE queries
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Why we lost Uber as a user