Re: neverending vacuum

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: neverending vacuum
Дата
Msg-id 1141052619.6846.263.camel@coppola.muc.ecircle.de
обсуждение исходный текст
Ответ на Re: neverending vacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
> So one very effective way of speeding this process up is giving the
> vacuum process lots of memory, because it will have to do fewer passes
> at each index.  How much do you have?

OK, this is my problem... it is left at default (16 megabyte ?). This
must be a mistake in configuration, on other similar boxes I set this to
262144 (256 megabyte). The box has 4 Gbyte memory.

Thanks for the explanation - you were right on the spot, it will likely
solve the problem.

Cheers,
Csaba.




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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: neverending vacuum
Следующее
От: Jamal Ghaffour
Дата:
Сообщение: The trigger can be specified to fire on time condition?