From: | "Sriram Dandapani" <sdandapani(at)counterpane(dot)com> |
---|---|
To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> |
Cc: | "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: transactoin id wraparound problem |
Date: | 2006-09-07 17:35:52 |
Message-ID: | 6992E470F12A444BB787B5C937B9D4DF05ABC97A@ca-mail1.cis.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Many thanks for this suggestion.
Vacuumdb -U <superuser> -a finished in 3 hours
Regards
Sriram
-----Original Message-----
From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
Sent: Thursday, September 07, 2006 7:03 AM
To: Sriram Dandapani
Cc: Scott Marlowe; Tom Lane; pgsql-admin(at)postgresql(dot)org
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Lane Van Ingen | 2006-09-07 18:16:44 | Re: Activating Contributions in 8.1.4 |
Previous Message | Lane Van Ingen | 2006-09-07 16:14:33 | Activating Contributions in 8.1.4 |