Re: [HACKERS] Checksums by default? - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: [HACKERS] Checksums by default?
Date
Msg-id CAM3SWZTkKePc7CK_Bp2-WmhtEsLB0MfStySq1hGfZ4TRXd7ctw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Checksums by default?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: [HACKERS] Checksums by default?  (Stephen Frost <sfrost@snowman.net>)
Re: [HACKERS] Checksums by default?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, Jan 23, 2017 at 5:26 PM, Stephen Frost <sfrost@snowman.net> wrote:
> Not sure how this part of that sentence was missed:
>
> -----
> ... even though they were enabled as soon as the feature became
> available.
> -----
>
> Which would seem to me to say "the code's been running for a long time
> on a *lot* of systems without throwing a false positive or surfacing a
> bug."

I think you've both understood what I said correctly. Note that I
remain neutral on the question of whether or not checksums should be
enabled by default.

Perhaps I've missed the point entirely, but, I have to ask: How could
there ever be false positives? With checksums, false positives are
simply not allowed. Therefore, there cannot be a false positive,
unless we define checksums as a mechanism that should only find
problems that originate somewhere at or below the filesystem. We
clearly have not done that, so ISTM that checksums could legitimately
find bugs in the checksum code. I am not being facetious.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Online enabling of page level checksums
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Checksums by default?