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
Import Notes
Reply to msg id not found: BrianAvis'smessageofFri14Dec2001143705-0900
Brian,
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
Use quotes:
/usr/local/pgsql/bin/psql -c "vacuum analyze" $database
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco