Skip site navigation (1) Skip section navigation (2)

9.3 feature proposal: vacuumdb -j #

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: 9.3 feature proposal: vacuumdb -j #
Date: 2012-01-13 21:50:32
Message-ID: 4F10A728.7090403@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hackers,

It occurs to me that I would find it quite personally useful if the
vacuumdb utility was multiprocess capable.

For example, just today I needed to manually analyze a database with
over 500 tables, on a server with 24 cores.   And I needed to know when
the analyze was done, because it was part of a downtime.  I had to
resort to a python script.

I'm picturing doing this in the simplest way possible: get the list of
tables and indexes, divide them by the number of processes, and give
each child process its own list.

Any reason not to hack on this for 9.3?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Responses

pgsql-hackers by date

Next:From: Jan LentferDate: 2012-01-13 22:03:16
Subject: Re: 9.3 feature proposal: vacuumdb -j #
Previous:From: Kevin GrittnerDate: 2012-01-13 21:44:51
Subject: Re: Remembering bug #6123

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group