en English

Re: PostgreSQL strugling during high load

в обсуждении

Список

Период

Сортировка

От:	Tom Lane
Тема:	Re: PostgreSQL strugling during high load
Дата:	13 мая 2005 г. , 14:12:45
Msg-id:	23517.1115993561@sss.pgh.pa.us (см: обсуждение, исходный текст)
Ответ на:	Re: PostgreSQL strugling during high load ("Mindaugas Riauba")
Ответы:	Re: PostgreSQL strugling during high load (Donald Courtney)
Список:	pgsql-performance

Показать дерево обсуждения

Скрыть дерево обсуждения

PostgreSQL strugling during high load ("Mindaugas Riauba", 13 мая 2005 г., 12:52:50 )
Re: PostgreSQL strugling during high load ("Steinar H. Gunderson", 13 мая 2005 г., 13:00:51 )
Re: PostgreSQL strugling during high load (Tom Lane, 13 мая 2005 г., 13:43:01 )
Re: PostgreSQL strugling during high load (Mischa Sandberg, 13 мая 2005 г., 17:33:31 )
Re: PostgreSQL strugling during high load ("Mindaugas Riauba", 13 мая 2005 г., 14:10:04 )
Re: PostgreSQL strugling during high load (Tom Lane, 13 мая 2005 г., 14:12:45 )
Re: PostgreSQL strugling during high load (Donald Courtney, 19 мая 2005 г., 16:55:39 )
Re: PostgreSQL strugling during high load (Cosimo Streppone, 13 мая 2005 г., 15:23:33 )
Re: PostgreSQL strugling during high load ("Matthew T. O'Connor", 16 мая 2005 г., 02:26:27 )
Re: PostgreSQL strugling during high load ("Thomas F. O'Connell", 16 мая 2005 г., 02:45:56 )
Re: PostgreSQL strugling during high load ("Mindaugas Riauba", 13 мая 2005 г., 14:45:59 )
Re: PostgreSQL strugling during high load ("Steinar H. Gunderson", 13 мая 2005 г., 16:12:24 )
Re: PostgreSQL strugling during high load ("Mindaugas Riauba", 13 мая 2005 г., 15:41:53 )
Re: PostgreSQL strugling during high load (Tom Lane, 13 мая 2005 г., 16:42:53 )
Re: PostgreSQL strugling during high load ("Mindaugas Riauba", 16 мая 2005 г., 10:05:16 )
Re: PostgreSQL strugling during high load ("Anjan Dave", 19 мая 2005 г., 18:12:26 )
Re: PostgreSQL strugling during high load (Donald Courtney, 19 мая 2005 г., 18:30:57 )
Re: PostgreSQL strugling during high load (Vivek Khera, 19 мая 2005 г., 19:43:02 )
Re: PostgreSQL strugling during high load (Josh Berkus, 19 мая 2005 г., 19:56:19 )
Re: PostgreSQL strugling during high load (Steve Poe, 19 мая 2005 г., 20:11:47 )
Re: PostgreSQL strugling during high load ("Anjan Dave", 19 мая 2005 г., 20:19:53 )

"Mindaugas Riauba" <> writes:
>   It looks like that not only vacuum causes our problems. vacuum_cost
> seems to lower vacuum impact but we are still noticing slow queries "storm".
> We are logging queries that takes >2000ms to process.
>   And there is quiet periods and then suddenly 30+ slow queries appears in
> log within the same second. What else could cause such behaviour?

Checkpoints?  You should ensure that the checkpoint settings are such
that checkpoints don't happen too often (certainly not oftener than
every five minutes or so), and make sure the bgwriter is configured
to dribble out dirty pages at a reasonable rate, so that the next
checkpoint doesn't have a whole load of stuff to write.

            regards, tom lane

В списке pgsql-performance по дате сообщения:

Предыдущее:

От: "Merlin Moncure"
Дата: 13 мая 2005 г., 13:56:53
Сообщение: Re: ok you all win what is best opteron (I dont want a hosed system again)

Следующее:

От: Andrew Sullivan
Дата: 13 мая 2005 г., 15:07:49
Сообщение: Re: Whence the Opterons?