Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM ANALYZE - Mailing list pgsql-general

From Shoaib Mir
Subject Re: VACUUM ANALYZE
Date
Msg-id bf54be870703262343x1a940326re3aa10b408416618@mail.gmail.com
Whole thread Raw
In response to VACUUM ANALYZE  ("Robert James" <srobertjames@gmail.com>)
List pgsql-general
Tree view
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)

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?



pgsql-general by date:

Previous
From: "Stuart Cooper"
Date:
Subject: Re: libpq dependencies
Next
From: "Pavan Deolasee"
Date:
Subject: Re: Strange result using transactions