Sriram Dandapani wrote:
> Ihave a 60Gb db on which I issued a vacuumdb -a call as a superuser. It
> as been running for about 20 hours. (All client connections have been
> disabled as well as jobs that access any table). I see 0% cpu
> utilization. The vacuumdb process by itself takes about 10% memory and
> postgres uses very little cpu and some io.(10-20%).
>
> Is there a way to tell vacuumdb to use more resources so it can run
> faster?
Maybe you have the vacuum cost delay parameters set? IIRC you should
drop vacuum_cost_delay to 0 if you want it to run as fast as possible.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.