Re: Initdb --data-checksums by default

On Wed, Apr 20, 2016 at 3:43 AM, Alex Ignatov <a.ignatov@postgrespro.ru> wrote:

What do you think about defaulting --data-checksums in initdb?

I think that ZFS storing my database files already does this and can correct for it using replicated copies, so why do I need a second layer of checksums?

Ms Windows doesnt have ZFS support. AIX also doesnt. Z/OS also.  Any other commercial Linux distros don't have ZFS support. Yes you can compile it and use on production but...
But PG runs on the above OS, but have check sum off by default. Thats the deal. And it is not related to ZFS existence or any other FS with checksums in any way. The question is only in performance hit when you turn it on and  now I am in the process of testing it...

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