Re: [HACKERS] Checksums by default? - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject Re: [HACKERS] Checksums by default?
Date
Msg-id 0A3221C70F24FB45833433255569204D1F6786AC@G01JPEXMBYT05
Whole thread Raw
In response to [HACKERS] Checksums by default?  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Magnus Hagander
> Is it time to enable checksums by default, and give initdb a switch to turn
> it off instead?
> 
> I keep running into situations where people haven't enabled it, because
> (a) they didn't know about it, or (b) their packaging system ran initdb
> for them so they didn't even know they could. And of course they usually
> figure this out once the db has enough data and traffic that the only way
> to fix it is to set up something like slony/bucardo/pglogical and a whole
> new server to deal with it.. (Which is something that would also be good
> to fix -- but having the default changed would be useful as well)

+10
I was wondering why the community had decided to turn it off by default.  IIRC, the reason was that the performance
overheadwas 20-30% when the entire data directory was placed on the tmpfs, but it's not as important as the data
protectionby default.
 

Regards
Takayuki Tsunakawa



pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: [HACKERS] Logical Replication WIP
Next
From: Michael Paquier
Date:
Subject: [HACKERS] Enabling replication connections by default in pg_hba.conf