Re: vacuumdb in parallel - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: vacuumdb in parallel
Date
Msg-id dcc563d10910131840l7c484636jd683321c54428f11@mail.gmail.com
Whole thread Raw
In response to vacuumdb in parallel  (Anj Adu <fotographs@gmail.com>)
Responses Re: vacuumdb in parallel
List pgsql-admin
On Tue, Oct 13, 2009 at 7:29 PM, Anj Adu <fotographs@gmail.com> wrote:
> I am running Postgres 8.1.9 on an 8 core Xeon 5430 box that is showing
> single digit CPU and IO utilization. the database size is 820G .
> Vacuum_cost_delay=0 and maintenance_mem = 900M
>
> Is there an option to vacuumdb or a way to make it run parallel threads.

I think that option showed up in 8.2 or 8.3.

pgsql-admin by date:

Previous
From: Anj Adu
Date:
Subject: vacuumdb in parallel
Next
From: Simon Riggs
Date:
Subject: Re: vacuumdb in parallel