Re: Using of --data-checksums - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Using of --data-checksums
Date
Msg-id 20200410202508.GB24987@momjian.us
Whole thread Raw
In response to Re: Using of --data-checksums  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Using of --data-checksums
List pgsql-general
On Wed, Apr  8, 2020 at 11:54:34AM -0400, Stephen Frost wrote:
> Greetings,
> 
> * BGoebel (b.goebel@prisma-computer.de) wrote:
> > initdb --data-checksums "... help to detect corruption by the I/O system"
> > There is an (negligible?) impact on performance, ok. 
> >  
> > Is there another reason NOT to use this feature ?
> 
> Not in my view.
> 
> > Has anyone had good or bad experience with the use of  --data-checksums?
> 
> Have had good experience with it.  We should really make it the default
> already.

Yeah, but I think we wanted more ability to change an existing cluster
before doing that since it would affect pg_upgraded servers.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Forcibly disconnect users from one database
Next
From: Stephen Frost
Date:
Subject: Re: Using of --data-checksums