Re: Getting Slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Getting Slow
Дата
Msg-id 11936.1181267173@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Getting Slow  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Getting Slow  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Also if autovacuum is eating all your I/O you may want to look into
> throttling it back a bit by setting autovacuum_vacuum_cost_delay to a
> non-zero value.

BTW, why is it that autovacuum_cost_delay isn't enabled by default?
I can hardly believe that anyone will want to run it without that.
*Especially* not with multiple workers configured by default.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: performance drop on 8.2.4, reverting to 8.1.4
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Getting Slow