Postgres Pro
Downloads
Home   >   mailing lists

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

From Alex Ignatov
Subject Re: Initdb --data-checksums by default
Date
Msg-id 5719FE86.7020209@postgrespro.ru
Whole thread Raw
In response to Re: Initdb --data-checksums by default  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view


On 21.04.2016 20:26, Vick Khera wrote:

On Thu, Apr 21, 2016 at 9:00 AM, Alex Ignatov <a.ignatov@postgrespro.ru> wrote:
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...

I don't care about those platforms, so changing the default is just making more work for me. :)
I see ;). By  the way following my tests turn this option on is only 1-2% overhead in throughput.
-- 
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

pgsql-general by date:

Previous
From: David Goodenough
Date:
Subject: Re: Proper relational database?
Next
From: Scott Ribe
Date:
Subject: Re: different empty array syntax requirements