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

From Michael Paquier
Subject Re: Enable data checksums by default
Date
Msg-id 20190329141014.GJ1954@paquier.xyz
Whole thread Raw
In response to Re: Enable data checksums by default  (Bernd Helmle <mailings@oopsware.de>)
Responses Re: Enable data checksums by default
List pgsql-hackers
On Fri, Mar 29, 2019 at 11:16:11AM +0100, Bernd Helmle wrote:
> So between ~7% to 18% impact with checksums in this specific case here.

I can't really believe that many people set up shared_buffers at 128kB
which would cause such a large number of page evictions, but I can
believe that many users have shared_buffers set to its default value
and that we are going to get complains about "performance drop after
upgrade to v12" if we switch data checksums to on by default.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pgsql: Improve autovacuum logging for aggressive andanti-wraparound ru
Next
From: Laurenz Albe
Date:
Subject: Re: table_privileges view always show object owner as a grantor