Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1avR2X-0006dY-NR for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Apr 2016 15:06:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1avR2X-0000Ba-0o for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Apr 2016 15:06:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1avR1B-00073W-Jq for pgsql-hackers@postgresql.org; Wed, 27 Apr 2016 15:04:45 +0000 Received: from mail-lf0-x230.google.com ([2a00:1450:4010:c07::230]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1avR14-0006Cn-4k for pgsql-hackers@postgresql.org; Wed, 27 Apr 2016 15:04:44 +0000 Received: by mail-lf0-x230.google.com with SMTP id j11so60123640lfb.1 for ; Wed, 27 Apr 2016 08:04:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc; bh=7qmovv0RuDsDEP3I+vCBeYUfiL2g0MBX1Dzoehp83Nk=; b=V/iKlrPWZp7eaaA9j2/8YlgbvcDus8XzcscGlZtlaagy8u76IZ1mpiiXnQjFt7BsYv qD0eS5tR2+UAT2PgyMlkUXQk1mNM34VUkqtavWscvACPB/47BMYoja0HEDIwYn8NB1RH iRj4duw99Dlbk4+ziOkIvkzD0PMHx8EFaJER0cFvK0X9uZ0+J33uqTald9k1L9a4EPrz 4rqjykseqi5kwcRbNDmFgrNZ6aQLRY/47lRjspbXmXIxoGvSy2Z7+wN8Zly1uHdGTo5Q c5lFwfTCEzi3W5CYC5oLZbb1dOpJ2BCWin1M0Zu7e0HJWPFGpMz+ZorBuF4Yu05YwMCS dDZw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc; bh=7qmovv0RuDsDEP3I+vCBeYUfiL2g0MBX1Dzoehp83Nk=; b=LmjyMZ5jFHoWkOLmOJ+3xQNVe07u6pBs+jCRaZ6cozdC+Mg2c7wiCQyOqe5USfTpfI sNoyVczfYpNSzok4UxQduVA7r6sn6vCAOrA1OfuyYuJ6gHJHc42kyfC1Egc8zR5bEW6R 8J3a2AGxY4wF3IwucS+At8Tbmcsr34y/ZfMnAyv/zL27pfJA8KZrvFhnD0/EUYM5N1+t TfJh6AABF03k3Lp87AQ0YK95lqYMvokyQ4/udW+IzNynpbbKK4x/Yz1HUq9FPLVMuU7t kXgFATgpPIxVWSgFKKsKzIvIdDMNNdxLvAQME6/hjAAMKDNxPdMGp7RgX5Dmu0aHrtgQ RwHg== X-Gm-Message-State: AOPr4FUYEXS+IICt4TcaFuN5pgaJ8NhRVhUTsW6DR7ZdKcTAECHQL7BUM+P9f59on16R6jR79vW8MW1E517pGK+/ MIME-Version: 1.0 X-Received: by 10.112.168.194 with SMTP id zy2mr3813153lbb.102.1461769477398; Wed, 27 Apr 2016 08:04:37 -0700 (PDT) Received: by 10.114.184.202 with HTTP; Wed, 27 Apr 2016 08:04:37 -0700 (PDT) In-Reply-To: <24748.1461764666@sss.pgh.pa.us> References: <20160427104307.GA4861@toroid.org> <57209AE7.9020906@2ndquadrant.com> <24748.1461764666@sss.pgh.pa.us> Date: Wed, 27 Apr 2016 23:04:37 +0800 Message-ID: Subject: Re: 9.6 and fsync=off From: Craig Ringer To: Tom Lane Cc: Petr Jelinek , Magnus Hagander , Abhijit Menon-Sen , PostgreSQL-development Content-Type: multipart/alternative; boundary=001a11c333f271cf0b053178baef X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --001a11c333f271cf0b053178baef Content-Type: text/plain; charset=UTF-8 On 27 April 2016 at 21:44, Tom Lane wrote: > Petr Jelinek 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!) > > Looks good. The docs on fsync are already good, it's just a matter of making people think twice and actually look at them. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services --001a11c333f271cf0b053178baef Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
On 2= 7 April 2016 at 21:44, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Petr Jelinek <petr@2ndquadrant.com> writes:
> +1 (Abhijit's wording with data loss changed to data corruption)
I'd suggest something like

#fsync =3D on=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0# flush data to disk for crash sa= fety
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 # (turni= ng this off can cause
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 # unreco= verable data corruption!)


Looks goo= d.

The docs on fsync are already good, it's ju= st a matter of making people think twice and actually look at them.=C2=A0

--
=C2=A0Craig Ringer=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 http://www.2n= dQuadrant.com/
=C2=A0PostgreSQL Development, 24x7 Support, Training = & Services
--001a11c333f271cf0b053178baef--