We're using PostgreSQL 8.1.11 on AIX 5.3 and we've been doing some
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
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
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?
Dan Langille -- http://www.langille.org/
pgsql-performance by date
|Next:||From: Joshua D. Drake||Date: 2008-02-15 22:04:53|
|Subject: Re: wal_sync_methods for AIX|
|Previous:||From: Erik Jones||Date: 2008-02-15 19:46:48|
|Subject: Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine|