Vacuum - Mailing list pgsql-general

From Brian Avis
Subject Vacuum
Date
Msg-id 3C1A8D21.9010809@searhc.org
Whole thread Raw
List pgsql-general
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



pgsql-general by date:

Previous
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: Pl/Tcl problem
Next
From: Philip Hallstrom
Date:
Subject: Re: Is there a PostgresQL equivalent to the DESCRIBE keyword???