Re: wal_sync_methods for AIX

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: wal_sync_methods for AIX
Дата
Msg-id 20080215140453.4fafd9b1@commandprompt.com
обсуждение исходный текст
Ответ на wal_sync_methods for AIX  (Dan Langille <dan@langille.org>)
Список 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 по дате отправления:

Предыдущее
От: Dan Langille
Дата:
Сообщение: wal_sync_methods for AIX
Следующее
От: Erik Jones
Дата:
Сообщение: Re: wal_sync_methods for AIX