-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, 15 Feb 2008 16:55:45 -0500 Dan Langille <dan@xxxxxxxxxxxx> 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----- ---------------------------(end of broadcast)---------------------------TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
