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?
BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
PGCon - The PostgreSQL Conference: http://www.pgcon.org/
In response to
pgsql-performance by date
|Next:||From: Erik Jones||Date: 2008-02-19 22:09:41|
|Subject: Re: wal_sync_methods for AIX|
|Previous:||From: Erik Jones||Date: 2008-02-19 21:32:02|
|Subject: Re: 7 hrs for a pg_restore?|