Re: PostgreSQL strugling during high load
От | Tom Lane |
---|---|
Тема | Re: PostgreSQL strugling during high load |
Дата | |
Msg-id | 23517.1115993561@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: PostgreSQL strugling during high load ("Mindaugas Riauba" <mind@bi.lt>) |
Ответы |
Re: PostgreSQL strugling during high load
|
Список | pgsql-performance |
"Mindaugas Riauba" <mind@bi.lt> 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 по дате отправления: