Search Postgresql Archives

Re: VACUUM ANALYZE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx > 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?




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux