From: Tom Lane <tgl@sss.pgh.pa.us>
To: Petr Jelinek <petr@2ndquadrant.com>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: 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 09:44:26 -0400
Message-ID: <24748.1461764666@sss.pgh.pa.us> (raw)
In-Reply-To: <57209AE7.9020906@2ndquadrant.com>
References: <CAMsr+YGechDvrFj4xwoBWhJ7rW25Avqo+UqcyqbnS=LTFdGJ4g@mail.gmail.com>
<20160427104307.GA4861@toroid.org>
<CABUevExGL-FWNP0pyCH_9nY==i1ogP-v8XNXpQyDaEp7u4ypCA@mail.gmail.com>
<57209AE7.9020906@2ndquadrant.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Petr Jelinek <petr@2ndquadrant.com> writes:
> +1 (Abhijit's wording with data loss changed to data corruption)
I'd suggest something like
#fsync = on # flush data to disk for crash safety
# (turning this off can cause
# unrecoverable data corruption!)
regards, tom lane
--
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: tgl@sss.pgh.pa.us, petr@2ndquadrant.com, magnus@hagander.net, ams@2ndquadrant.com, craig@2ndquadrant.com
Subject: Re: 9.6 and fsync=off
In-Reply-To: <24748.1461764666@sss.pgh.pa.us>
* 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