Re: Question about VACUUM

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Question about VACUUM
Дата
Msg-id CAOR=d=24U__8V=rB+khFM18by863EwREgFhDfqxy_YkiJiGTyw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question about VACUUM  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Question about VACUUM  (Ernesto Quiñones <ernestoq@gmail.com>)
Список pgsql-performance
On Mon, Dec 5, 2011 at 10:42 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Dec 5, 2011 at 10:19 AM, Ernesto Quiñones <ernestoq@gmail.com> wrote:
>> vacuum_cost_delay       1s
>> vacuum_cost_limit       200
>
> Those are insane settings for vacuum costing, even on a very slow
> machine.  Basically you're starving vacuum and autovacuum so much that
> they can never keep up.

sorry, the word I meant there was pathological.  No insult intended.

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Question about VACUUM
Следующее
От: Ernesto Quiñones
Дата:
Сообщение: Re: Question about VACUUM