Re: 9.6 and fsync=off

From: Petr Jelinek <petr(at)2ndquadrant(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>, Abhijit Menon-Sen <ams(at)2ndquadrant(dot)com>
Cc: Craig Ringer <craig(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 9.6 and fsync=off
Date: 2016-04-27 10:56:39
Message-ID: 57209AE7.9020906@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 27/04/16 12:53, Magnus Hagander wrote:
>
>
> On Wed, Apr 27, 2016 at 12:43 PM, Abhijit Menon-Sen <ams(at)2ndquadrant(dot)com
> <mailto:ams(at)2ndquadrant(dot)com>> wrote:
>
> At 2016-04-27 17:58:08 +0800, craig(at)2ndquadrant(dot)com
> <mailto:craig(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Abhijit Menon-Sen 2016-04-27 10:57:57 Re: 9.6 and fsync=off
Previous Message Magnus Hagander 2016-04-27 10:53:04 Re: 9.6 and fsync=off