From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Sriram Dandapani <sdandapani(at)counterpane(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 14:02:40 |
Message-ID: | 20060907140240.GB5892@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 | Andrew Sullivan | 2006-09-07 14:28:08 | Re: timezone Q for postgresql v814 |
Previous Message | Mr. Dan | 2006-09-07 14:00:31 | timezone Q for postgresql v814 |