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

From Bernd Helmle
Subject Re: Enable data checksums by default
Date
Msg-id 3586bb9345a59bfc8d13a50a7c729be1ee6759fd.camel@oopsware.de
Whole thread Raw
In response to Re: Enable data checksums by default  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Enable data checksums by default
List pgsql-hackers
Am Freitag, den 29.03.2019, 23:10 +0900 schrieb Michael Paquier:
> 
> 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.

Yeah, i think Christoph's benchmark is based on this thinking. I assume
this very unrealistic scenery should emulate the worst case (many
buffer_reads, high checksum calculation load). 

    Bernd





pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: monitoring CREATE INDEX [CONCURRENTLY]
Next
From: Alvaro Herrera
Date:
Subject: Re: monitoring CREATE INDEX [CONCURRENTLY]