Re: wal_sync_methods for AIX

[Erik Jones <erik(at)myemma(dot)com>]

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(at)myemma(dot)com
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