Skip site navigation (1) Skip section navigation (2)

wal_sync_methods for AIX

From: Dan Langille <dan(at)langille(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: wal_sync_methods for AIX
Date: 2008-02-15 21:55:45
Message-ID: 1959485A-0DC4-4EA3-864A-D40A7F8AA094@langille.org (view raw or flat)
Thread:
Lists: pgsql-performance
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.

Our tests have been on a p550 connected to DS6800 array using pgbench.

One nasty behaviour we have seen is long running commits. Initial  
thoughts connected
them with checkpoints, but the long running commits do not correlate  
with checkpoints being
written.  Have you seen this behaviour?

FYI, 8.3.0 is not an option for us in the short term.

What have you been using on AIX and why?

thanks

-- 
Dan Langille -- http://www.langille.org/
dan(at)langille(dot)org





Responses

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2008-02-15 22:04:53
Subject: Re: wal_sync_methods for AIX
Previous:From: Erik JonesDate: 2008-02-15 19:46:48
Subject: Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group