VACUUM ANALYZE

From: "Robert James" <srobertjames(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: VACUUM ANALYZE
Date: 2007-03-21 17:48:20
Message-ID: e09785e00703211048y1556dc71hd8105a38ca38e975@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-03-21 17:51:22 Re: best way to kill long running query?
Previous Message Robert James 2007-03-21 17:47:20 pg_dump without psql rights