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 5718CF02.9030001@postgrespro.ru
Whole thread Raw
In response to Re: Initdb --data-checksums by default  (Vick Khera <vivek@khera.org>)
Responses Re: Initdb --data-checksums by default
List pgsql-general
Tree view


On 20.04.2016 23:28, Vick Khera wrote:

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

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Next
From: Melvin Davidson
Date:
Subject: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created