From: Dan Langille <dan@langille.org>
To: Erik Jones <erik@myemma.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: wal_sync_methods for AIX
Date: Tue, 19 Feb 2008 16:58:19 -0500
Message-ID: <47BB50FB.4060608@langille.org> (raw)
In-Reply-To: <B7D41D70-CAD9-416E-AD9D-D391C5B7138B@myemma.com>
References: <1959485A-0DC4-4EA3-864A-D40A7F8AA094@langille.org>
<B7D41D70-CAD9-416E-AD9D-D391C5B7138B@myemma.com>
Erik Jones wrote:
>
> On Feb 15, 2008, at 3:55 PM, Dan Langille wrote:
>
>> We're using PostgreSQL 8.1.11 on AIX 5.3 and we've been doing some
>> playing around
>> with various settings. So far, we've (I say we, but it's another guy
>> doing the work) found
>> that open_datasync seems better than fsync. By how much, we have not
>> yet determined,
>> but initial observations are promising.
>
> Here's a good explanation (by the Greg Smith) on the different sync
> methods. It basically says that if you have open_datasync available,
> it'll probably beat everything else.
Where is that explanation?
--
Dan Langille
BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
PGCon - The PostgreSQL Conference: http://www.pgcon.org/
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: dan@langille.org, erik@myemma.com
Subject: Re: wal_sync_methods for AIX
In-Reply-To: <47BB50FB.4060608@langille.org>
* 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