Many thanks for this suggestion. Vacuumdb -U <superuser> -a finished in 3 hours Regards Sriram -----Original Message----- From: Alvaro Herrera [mailto:alvherre@xxxxxxxxxxxxxxxxx] Sent: Thursday, September 07, 2006 7:03 AM To: Sriram Dandapani Cc: Scott Marlowe; Tom Lane; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] transactoin id wraparound problem 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.
