Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? - Mailing list pgsql-performance

From Greg Smith
Subject Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Date
Msg-id 4CD47FCD.6010106@2ndquadrant.com
Whole thread Raw
In response to Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?  (Marti Raudsepp <marti@juffo.org>)
Responses Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
List pgsql-performance
Marti Raudsepp wrote:
> In fact, I was wrong in my earlier post. Linux always offered O_DSYNC
> behavior. What's new is POSIX-compliant O_SYNC, and the fact that
> these flags are now distinguished.
>

While I appreciate that you're trying to help here, I'm unconvinced
you've correctly diagnosed a couple of components to what's going on
here properly yet.  Please refrain from making changes to popular
documents like the tuning guide on the wiki based on speculation about
what's happening.  There's definitely at least one mistake in what you
wrote there, and I just reverted the whole set of changes you made
accordingly until this is sorted out better.

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services and Support        www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books


pgsql-performance by date:

Previous
From: Samuel Gendler
Date:
Subject: Re: Simple (hopefully) throughput question?
Next
From: Josh Berkus
Date:
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?