Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: VACUUM ANALYZE
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Robert James" <srobertjames(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: VACUUM ANALYZE
- Date: Thu, 22 Mar 2007 23:32:53 -0400
- Message-id: <1501(dot)1174620773(at)sss(dot)pgh(dot)pa(dot)us>
"Robert James" <srobertjames(at)gmail(dot)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
- References:
- VACUUM ANALYZE
- From: Robert James
- VACUUM ANALYZE
- Prev by Date: VACUUM ANALYZE
- Next by Date: How to get the DML Commands exceuted from functions
- Previous by thread: VACUUM ANALYZE
- Next by thread: foreign key constraints with inhertiance, hack suggestions?
- Indexes: