Re: PostgreSQL strugling during high load

Поиск
Список
Период
Сортировка
От Mischa Sandberg
Тема Re: PostgreSQL strugling during high load
Дата
Msg-id 1116005602.4284e4e28869e@webmail.telus.net
обсуждение исходный текст
Ответ на Re: PostgreSQL strugling during high load  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Quoting Tom Lane <tgl@sss.pgh.pa.us>:

> "Mindaugas Riauba" <mind@bi.lt> writes:
> > ... So contents of database changes very fast. Problem is that
> when
> > pg_autovacuum does vacuum those changes slows down too much.
>
> The "vacuum cost" parameters can be adjusted to make vacuums fired
> by pg_autovacuum less of a burden.  I haven't got any specific
> numbers
> to suggest, but perhaps someone else does.

I solved one problem by cranking sleep scaling to -S 20.
It made pg_autovacuum back off longer during extended periods of heavy
disk-intensive query activity. Our update activity is near-constant
insert rate, then once or twice a day, massive deletes.
--
Dreams come true, not free.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL strugling during high load
Следующее
От: John A Meinel
Дата:
Сообщение: Re: Optimize complex join to use where condition before