VACUUM ANALYZE
Started by Robert Jamesabout 19 years ago2 messagesgeneral
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.
Is that true? How can I see the results of the automatic vacuum analyze? Or
configure them?
Re: VACUUM ANALYZE
Yes, that is true if you have the autovacuum setting enabled for the
database server. You can see the last auto vacuum and last auto analyze
timestamp values from pg_stat_all_tables.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
Show quoted text
On 3/21/07, Robert James <srobertjames@gmail.com> wrote:
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.Is that true? How can I see the results of the automatic vacuum analyze?
Or configure them?