Re: Initdb --data-checksums by default - Mailing list pgsql-general

From Michael Paquier
Subject Re: Initdb --data-checksums by default
Date
Msg-id CAB7nPqTwHwETW4LYdWDE4WKkBDrPZtjjZzXngGv4Tx_t_YtrDg@mail.gmail.com
Whole thread Raw
In response to Initdb --data-checksums by default  (Alex Ignatov <a.ignatov@postgrespro.ru>)
Responses Re: Initdb --data-checksums by default
List pgsql-general
On Wed, Apr 20, 2016 at 4:43 PM, Alex Ignatov <a.ignatov@postgrespro.ru> wrote:
> Hello everyone!
> Today in Big Data epoch silent data corruption becoming more and more issue
> to afraid of. With uncorrectable read error rate ~ 10^-15   on multiterabyte
> disk bit rot is the real issue.
> I think that today checksumming data  must be mandatory  set by default.
> Only if someone doesn't care about his data he can manually turn this option
> off.
>
> What do you think about defaulting --data-checksums in initdb?

Not sure that most users deploying Postgres by default are ready to
pay the price of data checksums in their default deployments. People
using it are already using the -k switch, so it may actually be a trap
to switch the default.
--
Michael


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Initdb --data-checksums by default
Next
From: Alex Ignatov
Date:
Subject: Re: Initdb --data-checksums by default