Skip site navigation (1) Skip section navigation (2)

Vacuum

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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



Responses

  • 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 McNaughtDate: 2001-12-15 00:09:20
Subject: Re: Vacuum
Previous:From: Josh BerkusDate: 2001-12-14 19:13:41
Subject: Re: Storing number '001' ?

pgsql-general by date

Next:From: Philip HallstromDate: 2001-12-14 23:46:38
Subject: Re: Is there a PostgresQL equivalent to the DESCRIBE keyword???
Previous:From: Joe KoenigDate: 2001-12-14 23:22:09
Subject: Warning: PostgreSQL query failed: PQexec: you gotta get out of a COPY state yourself.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group