Re: Vacuum wait time problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum wait time problem
Дата
Msg-id 26754.1234731725@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Vacuum wait time problem  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> I don't know what other people have found useful, but when I
> experimented with this in our environment, it seemed like I should
> just treat vacuum_cost_delay as a boolean, where 0 meant off and 10
> meant on, and tune it by adjusting vacuum_cost_limit.  The granularity
> of vacuum_cost_delay is course and surprising unpredictable.

Making it a boolean is a bit further than I care to go ;-)

What I'd suggest at this point is changing the upper limit to 100ms
(from 1000) and adding documentation suggesting that the value should
be kept small, preferring to use the other vacuum_cost parameters to
tune the behavior.

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Vacuum wait time problem
Следующее
От: Haluk Durmus
Дата:
Сообщение: initdb causes Segmentation fault