Re: vacuumdb in parallel - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: vacuumdb in parallel
Date
Msg-id dcc563d10910140045r2dfaea1l23da9dbc5956409c@mail.gmail.com
Whole thread Raw
In response to Re: vacuumdb in parallel  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-admin
On Wed, Oct 14, 2009 at 1:34 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Tue, 2009-10-13 at 19:40 -0600, Scott Marlowe wrote:
>> 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.
>
> There is no option to do that yet at any release.
>
> We have parallel pg_restore, but that doesn't apply to vacuumdb,
> reindexdb, clusterdb or any custom written jobs.
>
> You need to break out your top few tables into separate jobs, e.g.
> vacuumdb -t big1
> vacuumdb -t big2

I was thinking of autovacuum, which does indeed have that option.
Much simpler to me, just set the autovac thresholds right and it's
automatic.

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: vacuumdb in parallel
Next
From: Alberto Asuero Arroyo
Date:
Subject: how to restore postgre 8.3 from data directory