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

Re: Vacuum

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Brian Avis <brian(dot)avis(at)searhc(dot)org>, pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Vacuum
Date: 2001-12-15 00:48:02
Message-ID: web-529312@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
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(at)agliodbs(dot)com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

In response to

  • Vacuum at 2001-12-14 23:37:05 from Brian Avis

pgsql-novice by date

Next:From: Fernando M. MarescaDate: 2001-12-15 21:50:01
Subject: Import DB from DOS- dbase4
Previous:From: Doug McNaughtDate: 2001-12-15 00:09:20
Subject: Re: Vacuum

pgsql-general by date

Next:From: Martin WeinbergDate: 2001-12-15 03:36:25
Subject: Re: Problem with OID wrap
Previous:From: Raymond Curtis RodgersDate: 2001-12-15 00:14:29
Subject: 7.2 back to 7.1.3

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