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

From Alvaro Herrera
Subject Re: Initdb --data-checksums by default
Date
Msg-id 20160420135808.GA855511@alvherre.pgsql
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
Alex Ignatov 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.

In principle I support the idea of turning data checksums by default,
but can you provide some numbers on how it affects performance on
various workloads?  That's a critical point in the discussion.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Initdb --data-checksums by default
Next
From:
Date:
Subject: Re: How do BEGIN/COMMIT/ABORT operate in a nested SPI query?