| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2008-02-15 22:04:53 | Re: wal_sync_methods for AIX |
| Previous Message | Erik Jones | 2008-02-15 19:46:48 | Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine |