Re: autovacuum strategy / parameters

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: autovacuum strategy / parameters
Дата
в 08:39:17
Msg-id
AANLkTik9xSarBYBapF1CVrPoRuqimyGAFAgOaGgvHpLR@mail.gmail.com
Ответ на
Список
Дерево обсуждения
autovacuum strategy / parameters Rick <richard.branton@ca.com>
Re: autovacuum strategy / parameters Robert Haas <robertmhaas@gmail.com>
On Fri, Apr 30, 2010 at 6:50 PM, Josh Berkus  wrote:
> Which is the opposite of my experience; currently we have several
> clients who have issues which required more-frequent analyzes on
> specific tables.

That's all fine, but probably not too relevant to the original
complaint - the OP backed off the default settings by several orders
of magnitude, which might very well cause a problem with both VACUUM
and ANALYZE.

I don't have a stake in the ground on what the right settings are, but
I think it's fair to say that if you vacuum OR analyze much less
frequently than what we recommend my default, it might break.

...Robert
В списке pgsql-performance по дате отправления
От: Cédric Villemain
Дата:
Сообщение: Re: Optimization idea
От: Cédric Villemain
Дата:
Сообщение: Re: Optimization idea
FAQ