Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM ANALYZE - Mailing list pgsql-general

From Tom Lane
Subject Re: VACUUM ANALYZE
Date
Msg-id 1501.1174620773@sss.pgh.pa.us
Whole thread Raw
In response to VACUUM ANALYZE  ("Robert James" <srobertjames@gmail.com>)
List pgsql-general
Tree view 
"Robert James" <srobertjames@gmail.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

pgsql-general by date:

Previous
From: "Robert James"
Date:
Subject: VACUUM ANALYZE
Next
From: "Anoo Pillai"
Date:
Subject: How to get the DML Commands exceuted from functions