From: Petr Jelinek <petr@2ndquadrant.com>
To: Magnus Hagander <magnus@hagander.net>
To: Abhijit Menon-Sen <ams@2ndquadrant.com>
Cc: Craig Ringer <craig@2ndquadrant.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: 9.6 and fsync=off
Date: Wed, 27 Apr 2016 12:56:39 +0200
Message-ID: <57209AE7.9020906@2ndquadrant.com> (raw)
In-Reply-To: <CABUevExGL-FWNP0pyCH_9nY==i1ogP-v8XNXpQyDaEp7u4ypCA@mail.gmail.com>
References: <CAMsr+YGechDvrFj4xwoBWhJ7rW25Avqo+UqcyqbnS=LTFdGJ4g@mail.gmail.com>
<20160427104307.GA4861@toroid.org>
<CABUevExGL-FWNP0pyCH_9nY==i1ogP-v8XNXpQyDaEp7u4ypCA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: petr@2ndquadrant.com, magnus@hagander.net, ams@2ndquadrant.com, craig@2ndquadrant.com
Subject: Re: 9.6 and fsync=off
In-Reply-To: <57209AE7.9020906@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox