public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Sabino Mullane <[email protected]>
To: bruno vieira da silva <[email protected]>
Cc: [email protected]
Subject: Re: data checksums
Date: Tue, 6 Aug 2024 12:29:55 -0400
Message-ID: <CAKAnmm+mSMJgOGK9YevVVZhE2FzPpyO2W6Npk1UbuHzqa_ffdA@mail.gmail.com> (raw)
In-Reply-To: <CAB+Nuk8y88kvoRHsfN2Pjed9o_iM+9FbveU=4P8G0EQbzFP+qw@mail.gmail.com>
References: <CAB+Nuk8y88kvoRHsfN2Pjed9o_iM+9FbveU=4P8G0EQbzFP+qw@mail.gmail.com>
The penalty is not "considerable", but it is not completely trivial either.
But it's more on the trivial side. Part of the problem is that it is hard
to measure, as it is very workload dependent. As to why it is not the
default, Postgres is very careful and conservative by default, and not
everybody was convinced that enabling checksums is worth the tradeoff,
especially (IIRC) with the lack of real-world examples of people
discovering issues thanks to these checksums. So yes, please enable and
share with us if the checksums catch anything.
I think the argument is worth re-opening again, because (as far as I know),
all of the companies providing Postgres support, whether completely
cloud-managed, setting up a complex HA cluster, or just providing tuning
advice, have enabled checksums by default for many, many years. So a big +1
from me to finally making it the default. It's a de-facto default anyway at
this point.
Cheers,
Greg
view thread (8+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: data checksums
In-Reply-To: <CAKAnmm+mSMJgOGK9YevVVZhE2FzPpyO2W6Npk1UbuHzqa_ffdA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox