Allowing multi "-t" and adding "-n" to vacuumdb ?

From: "Jehan-Guillaume (ioguix) de Rorthais" <jgdr(at)dalibo(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Allowing multi "-t" and adding "-n" to vacuumdb ?
Date: 2012-03-01 16:36:46
Message-ID: 4F4FA59E.7090503@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

One of our customer send us a patch he wrote for his needs (on
"src/bin/scripts/vacuumdb.c", no doc were included).

He's using one schema per application and would like to be able to run
vacuumdb on each of them independently so he added the "--schema|-n"
option and send us the patch.

Reviewing his patch, I thought it would be more useful to allow multi
"--table|-t" options on the command line first. It might be possible to
pass an array of tables to "vacuum_one_database" function instead of
just one.

Then, we could add the "--schema|-n" option which would fetch and build
the table list and call "vacuum_one_database".

But before I start writing this patch, I would like some opinion, pros /
cons. Do you think such a feature could be accepted in official
PostgreSQL code or should we keep this as an external script ?

Thank you,
--
Jehan-Guillaume (ioguix) de Rorthais
http://www.dalibo.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-03-01 16:38:42 Re: performance results on IBM POWER7
Previous Message Ants Aasma 2012-03-01 16:23:28 Re: performance results on IBM POWER7