| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Weinberg | 2001-12-15 03:36:25 | Re: Problem with OID wrap |
| Previous Message | Raymond Curtis Rodgers | 2001-12-15 00:14:29 | 7.2 back to 7.1.3 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fernando M. Maresca | 2001-12-15 21:50:01 | Import DB from DOS- dbase4 |
| Previous Message | Doug McNaught | 2001-12-15 00:09:20 | Re: Vacuum |