Skip site navigation (1) Skip section navigation (2)

Re: wal_sync_methods for AIX

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Dan Langille <dan(at)langille(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: wal_sync_methods for AIX
Date: 2008-02-15 22:04:53
Message-ID: 20080215140453.4fafd9b1@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 15 Feb 2008 16:55:45 -0500
Dan Langille <dan(at)langille(dot)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-----

In response to

Responses

pgsql-performance by date

Next:From: Erik JonesDate: 2008-02-15 22:20:25
Subject: Re: wal_sync_methods for AIX
Previous:From: Dan LangilleDate: 2008-02-15 21:55:45
Subject: wal_sync_methods for AIX

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group