Re: vacuumdb in parallel

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Anj Adu <fotographs(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuumdb in parallel
Date: 2009-10-14 01:40:34
Message-ID: dcc563d10910131840l7c484636jd683321c54428f11@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Oct 13, 2009 at 7:29 PM, Anj Adu <fotographs(at)gmail(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2009-10-14 07:34:22 Re: vacuumdb in parallel
Previous Message Anj Adu 2009-10-14 01:29:58 vacuumdb in parallel