Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Carey <scott(at)richrelevance(dot)com>
Cc: Marti Raudsepp <marti(at)juffo(dot)org>, Greg Smith <greg(at)2ndquadrant(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Date: 2010-11-08 18:40:34
Message-ID: 27402.1289241634@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Scott Carey <scott(at)richrelevance(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pierre C 2010-11-08 18:41:53 Re: Select * is very slow
Previous Message Scott Carey 2010-11-08 18:13:43 Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?