pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Carey <scott@richrelevance.com>
Cc: Marti Raudsepp <marti@juffo.org>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Date: Mon, 08 Nov 2010 13:40:34 -0500
Message-ID: <27402.1289241634@sss.pgh.pa.us> (raw)
In-Reply-To: <9D7DB2F2-683B-480C-B781-8D282A280E35@richrelevance.com>
References: <AANLkTi=n3zxiLNFhbpiN=JPQPwB=BhXf9iepw1KOEs8U@mail.gmail.com>
	<4CCDCAA3.4050805@2ndquadrant.com>
	<201011010010.28724.andres@anarazel.de>
	<4CD472CC.80006@2ndquadrant.com>
	<AANLkTinEAmKDz7x356bgX=-6x7zpjK3bB0hYAmKvYHB9@mail.gmail.com>
	<4CD47FCD.6010106@2ndquadrant.com>
	<AANLkTimhNzer1TOEnL55P-Un9TPp8fAeyOzX09259RxN@mail.gmail.com>
	<4CD737C1.9070502@2ndquadrant.com>
	<AANLkTinZ6Vw58v9_7tSPox-f1nmCyV1K4XOxuaJiDkgo@mail.gmail.com>
	<9D7DB2F2-683B-480C-B781-8D282A280E35@richrelevance.com>

Scott Carey <scott@richrelevance.com> writes:
> No matter how you slice it, the default on Linux is implicitly changing and the choice is to either:
>  * Return the default to fdatasync
>  * Let it implicitly change to O_DSYNC

> The latter choice is the one that requires testing to prove that it is the proper and preferred default from the performance and data reliability POV.

And, in fact, the game plan is to do that testing and see which default
we want.  I think it's premature to argue further about this until we
have some test results.

			regards, tom lane



view thread (46+ messages)  latest in thread

Message-ID: <27402.1289241634@sss.pgh.pa.us>
Permalink:  ../27402.1289241634@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/27402.1289241634@sss.pgh.pa.us

 · 

reply
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-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, scott@richrelevance.com, marti@juffo.org, greg@2ndquadrant.com, andres@anarazel.de
  Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
  In-Reply-To: <27402.1289241634@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