From: | Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru> |
---|---|
To: | Vick Khera <vivek(at)khera(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Initdb --data-checksums by default |
Date: | 2016-04-22 10:35:50 |
Message-ID: | 5719FE86.7020209@postgrespro.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 21.04.2016 20:26, Vick Khera wrote:
>
> On Thu, Apr 21, 2016 at 9:00 AM, Alex Ignatov
> <a(dot)ignatov(at)postgrespro(dot)ru <mailto:a(dot)ignatov(at)postgrespro(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2016-04-22 11:13:13 | Re: different empty array syntax requirements |
Previous Message | David Goodenough | 2016-04-22 10:21:30 | Re: Proper relational database? |