Re: Initdb --data-checksums by default

On 20.04.2016 16:58, Alvaro Herrera wrote:
> 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.
>
Right now i am working on this tests. On various media - hdd ssd ram and
some various workload. As soon as results be ready i'll provide my numbers

--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company