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. :)
SEARHC Medical Clinic
Juneau, AK 99801
- Re: Vacuum at 2001-12-15 00:09:20 from Doug McNaught
- Re: Vacuum at 2001-12-15 00:48:02 from Josh Berkus
pgsql-novice by date
|Next:||From: Doug McNaught||Date: 2001-12-15 00:09:20|
|Subject: Re: Vacuum|
|Previous:||From: Josh Berkus||Date: 2001-12-14 19:13:41|
|Subject: Re: Storing number '001' ?|
pgsql-general by date
|Next:||From: Philip Hallstrom||Date: 2001-12-14 23:46:38|
|Subject: Re: Is there a PostgresQL equivalent to the DESCRIBE keyword???|
|Previous:||From: Joe Koenig||Date: 2001-12-14 23:22:09|
|Subject: Warning: PostgreSQL query failed: PQexec: you gotta get out of a COPY