Re: 9.6 and fsync=off - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: 9.6 and fsync=off
Date
Msg-id CABUevExGL-FWNP0pyCH_9nY==i1ogP-v8XNXpQyDaEp7u4ypCA@mail.gmail.com
Whole thread Raw
In response to Re: 9.6 and fsync=off  (Abhijit Menon-Sen <ams@2ndQuadrant.com>)
Responses Re: 9.6 and fsync=off  (Petr Jelinek <petr@2ndquadrant.com>)
List pgsql-hackers


On Wed, Apr 27, 2016 at 12:43 PM, Abhijit Menon-Sen <ams@2ndquadrant.com> wrote:
At 2016-04-27 17:58:08 +0800, craig@2ndquadrant.com wrote:
>
> #fsync = on                             # turns forced synchronization on or off

I suggest:                                # provide crash safety by flushing disk writes
                                          # (Disabling this can lead to unrecoverable data
                                          # loss if the system crashes.)

+1 for the change. I suggest shortening it to just "disabling this can lead to unrecoverable data corruption" (I think corruption is better than loss, mainly because too many people equate loss with "i may loose my last 10 updates, and I'm fine with that).

--

pgsql-hackers by date:

Previous
From: Abhijit Menon-Sen
Date:
Subject: Re: 9.6 and fsync=off
Next
From: Petr Jelinek
Date:
Subject: Re: 9.6 and fsync=off