Thread: Vacuum

Sorry if this is a double post, I can't tell if it made it the first
time so will try again.

Right now I am running vacuum like this from a script.

/usr/local/pgsql/bin/psql -c vacuum $database

 From the reading I have done I am led to believe that running vacuum
analyze is the better way to go. But if I change to line to this.

/usr/local/pgsql/bin/psql -c vacuum analyze $database

I get these errors.

psql: FATAL 1:  Database "analyze" does not exist in the system catalog

So how do I do a vacuum analyze?

Thank you for you assistance.  :)


--
Brian Avis
SEARHC Medical Clinic
Juneau, AK 99801
(907) 463-4049
cd /pub
more beer

Brian Avis <brian.avis@searhc.org> writes:

> So how do I do a vacuum analyze?

$ vacuumdb -z $database

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863