Re: Initdb --data-checksums by default

Alex Ignatov <a.ignatov@xxxxxxxxxxxxxx> · Thu, 21 Apr 2016 16:00:50 +0300



    On 20.04.2016 23:28, Vick Khera wrote:

    
          On Wed, Apr 20, 2016 at 3:43 AM, Alex
            Ignatov <a.ignatov@xxxxxxxxxxxxxx>
            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