| From: | "Shoaib Mir" <shoaibmir(at)gmail(dot)com> |
|---|---|
| To: | "Robert James" <srobertjames(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: VACUUM ANALYZE |
| Date: | 2007-03-27 06:43:19 |
| Message-ID: | bf54be870703262343x1a940326re3aa10b408416618@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmail(dot)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?
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pol | 2007-03-27 07:02:39 | to build a vocabulary |
| Previous Message | Richard Huxton | 2007-03-27 06:35:55 | Re: Problem with transactions |