Re: vacuuming problems continued

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vacuuming problems continued
Дата
Msg-id 12384.1149174355@sss.pgh.pa.us
обсуждение исходный текст
Ответ на vacuuming problems continued  (Antoine <melser.anton@gmail.com>)
Ответы Re: vacuuming problems continued  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-performance
Antoine <melser.anton@gmail.com> writes:
> We just don't seem to be getting much benefit from autovacuum. Running
> a manual vacuum seems to still be doing a LOT, which suggests to me
> that I should either run a cron job and disable autovacuum, or just
> run a cron job on top of autovacuum.

The default autovac parameters are very unaggressive --- have you
experimented with changing them?  Do you have the FSM set large enough?

            regards, tom lane

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

Предыдущее
От: Antoine
Дата:
Сообщение: vacuuming problems continued
Следующее
От: "Joao"
Дата:
Сообщение: help me problems with pg_clog file