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.
