Bill Moran wrote:
> In response to Ron St-Pierre <ron.pgsql@shaw.ca>:
>
>
>> We vacuum only a few of our tables nightly, this one is the last one
>> because it takes longer to run. I'll probably re-index it soon, but I
>> would appreciate any advice on how to speed up the vacuum process (and
>> the db in general).
>>
>
> I doubt anyone can provide meaningful advice without the output of
> vacuum verbose.
>
>
The cron job is still running
/usr/local/pgsql/bin/vacuumdb -d imperial -t stock.fdata -v -z >
/usr/local/pgsql/bin/fdata.txt
I'll post the output when it's finished.

Ron


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match