On Feb 19, 2008, at 3:58 PM, Dan Langille wrote:
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?
Sorry, did I leave off the link? http://www.westnet.com/~gsmith/
content/postgresql/TuningPGWAL.htm
Erik Jones
DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
