On Wed, Oct 14, 2009 at 1:34 AM, Simon Riggs <simon@xxxxxxxxxxxxxxx> 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@xxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
