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