Re: VACUUM ANALYZE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: VACUUM ANALYZE
Дата
Msg-id 1501.1174620773@sss.pgh.pa.us
обсуждение исходный текст
Ответ на VACUUM ANALYZE  ("Robert James" <srobertjames@gmail.com>)
Список pgsql-general
"Robert James" <srobertjames@gmail.com> writes:
> I see in all the docs to run VACUUM ANALYZE periodically. My host told me
> that in Postgres 8.2 this is not needed as it is done automatically.

8.2 has an autovacuum feature but it is *not* turned on by default ...
has your host enabled it?

> Is that true? How can I see the results of the automatic vacuum analyze? Or
> configure them?

See the autovacuum info in the documentation.

            regards, tom lane

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

Предыдущее
От: "Robert James"
Дата:
Сообщение: VACUUM ANALYZE
Следующее
От: "Anoo Pillai"
Дата:
Сообщение: How to get the DML Commands exceuted from functions