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?
--
Dan Langille
BSDCan - The Technical BSD Conference : http://www.bsdcan.org/
PGCon - The PostgreSQL Conference: http://www.pgcon.org/
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
