Re: large table vacuum issues

Поиск
Список
Период
Сортировка
От Ed L.
Тема Re: large table vacuum issues
Дата
Msg-id 200801041829.10350.pgsql@bluepolka.net
обсуждение исходный текст
Ответ на Re: large table vacuum issues  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: large table vacuum issues  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
On Friday 04 January 2008 6:21 pm, Scott Marlowe wrote:
>
> Have you tried adjusting the
>
> #vacuum_cost_delay = 0                  # 0-1000 milliseconds
> #vacuum_cost_page_hit = 1               # 0-10000 credits
> #vacuum_cost_page_miss = 10             # 0-10000 credits
> #vacuum_cost_page_dirty = 20            # 0-10000 credits
> #vacuum_cost_limit = 200                # 0-10000 credits
>
> settings to something so as to make vacuum less intrusive?
> might be the easiest fix.

Any particular suggested changes for these parameters?

Ed

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: large table vacuum issues
Следующее
От: "Ed L."
Дата:
Сообщение: Re: large table vacuum issues