On Tue, Aug 6, 2024 at 11:12 AM bruno vieira da silva <brunogiovs@gmail.com> wrote:
Hello.
I've been dealing with some database corruption events, so i've been wondering to enable data checksums on my deployments.
so my question is why data checksums aren't enabled by default on pg? the pg doc
mentions a considerable performance penality, how considerable it is?
I'm going to hazard a guess that the relevant line from the docs were written many many years ago, back when servers were much slower.
We certainly didn't notice any speed degradation when going from PG 9.6.24 to PG 14.12. Or... we just use enough hardware and flash-only SAN disks to make the overhead minuscule.
