Re: wal_sync_methods for AIX - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: wal_sync_methods for AIX
Date
Msg-id 20080215140453.4fafd9b1@commandprompt.com
Whole thread Raw
In response to wal_sync_methods for AIX  (Dan Langille <dan@langille.org>)
List pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 15 Feb 2008 16:55:45 -0500
Dan Langille <dan@langille.org> wrote:

> 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?

Are you sure? What makes you think this? Do you have a high level of
shared buffers? What are your bgwriter settings?

Joshua D. Drake




- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHtgyFATb/zqfZUUQRAv2LAJ41l25YG7PwfgpZtuPD/1aL5I4ZTwCfRGii
LkFFefSDT72qGzY8PxOMXKE=
=0iC3
-----END PGP SIGNATURE-----

pgsql-performance by date:

Previous
From: Dan Langille
Date:
Subject: wal_sync_methods for AIX
Next
From: Erik Jones
Date:
Subject: Re: wal_sync_methods for AIX