Re: Enable data checksums by default - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: Enable data checksums by default
Date
Msg-id 7e24ec00f772ef168c298032c5575392d3b9b09f.camel@cybertec.at
Whole thread Raw
In response to Re: Enable data checksums by default  (Tomas Vondra <tomas@vondra.me>)
Responses Re: Enable data checksums by default
List pgsql-hackers
On Tue, 2025-07-29 at 20:24 +0200, Tomas Vondra wrote:
> So, what should we do with the PG18 open item? We (the RMT team) would
> like to know if we shall keep the checksums enabled by default, and if
> there's something that still needs to be done for PG18.

I don't have a strong opinion, but I lean towards having them on
by default.  Yes, that has a performance impact (e.g. WAL logging hints),
and people with reliable storage may be better off disabling checksums.
But I think it is better to set the default values so that they are
good for those people who don't have a lot of PostgreSQL knowledge and
are running less demanding installations on mediocre hardware.

Yours,
Laurenz Albe



pgsql-hackers by date:

Previous
From: Ajin Cherian
Date:
Subject: Re: 024_add_drop_pub.pl might fail due to deadlock
Next
From: Dmitry Dolgov
Date:
Subject: Re: Automatically sizing the IO worker pool