| From: | Brian Avis <brian(dot)avis(at)searhc(dot)org> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Vacuum |
| Date: | 2001-12-14 23:37:05 |
| Message-ID: | 3C1A8D21.9010809@searhc.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Hallstrom | 2001-12-14 23:46:38 | Re: Is there a PostgresQL equivalent to the DESCRIBE keyword??? |
| Previous Message | Joe Koenig | 2001-12-14 23:22:09 | Warning: PostgreSQL query failed: PQexec: you gotta get out of a COPY state yourself. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2001-12-15 00:09:20 | Re: Vacuum |
| Previous Message | Josh Berkus | 2001-12-14 19:13:41 | Re: Storing number '001' ? |