Re: AdvanceXLInsertBuffer vs. WAL segment compressibility - Mailing list pgsql-hackers

From Chapman Flack
Subject Re: AdvanceXLInsertBuffer vs. WAL segment compressibility
Date
Msg-id 886a3377-9f2d-2176-15f7-b9ac1eb4dce7@anastigmatix.net
Whole thread Raw
In response to Re: AdvanceXLInsertBuffer vs. WAL segment compressibility  (Bruce Momjian <bruce@momjian.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: TODO item: Implement Boyer-Moore searching in LIKE queries
Next
From: Robert Haas
Date:
Subject: Re: Why we lost Uber as a user