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

From Petr Jelinek
Subject Re: 9.6 and fsync=off
Date
Msg-id 57209AE7.9020906@2ndquadrant.com
Whole thread Raw
In response to Re: 9.6 and fsync=off  (Magnus Hagander <magnus@hagander.net>)
Responses Re: 9.6 and fsync=off  (Abhijit Menon-Sen <ams@2ndQuadrant.com>)
Re: 9.6 and fsync=off  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 27/04/16 12:53, Magnus Hagander wrote:
>
>
> On Wed, Apr 27, 2016 at 12:43 PM, Abhijit Menon-Sen <ams@2ndquadrant.com
> <mailto:ams@2ndquadrant.com>> wrote:
>
>     At 2016-04-27 17:58:08 +0800, craig@2ndquadrant.com
>     <mailto: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).
>

+1 (Abhijit's wording with data loss changed to data corruption)

--   Petr Jelinek                  http://www.2ndQuadrant.com/  PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

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