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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2008-02-15 22:20:25 | Re: wal_sync_methods for AIX |
Previous Message | Dan Langille | 2008-02-15 21:55:45 | wal_sync_methods for AIX |