Allowing multi "-t" and adding "-n" to vacuumdb ? - Mailing list pgsql-hackers

From Jehan-Guillaume (ioguix) de Rorthais
Subject Allowing multi "-t" and adding "-n" to vacuumdb ?
Date
Msg-id 4F4FA59E.7090503@dalibo.com
Whole thread Raw
Responses Re: Allowing multi "-t" and adding "-n" to vacuumdb ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Ants Aasma
Date:
Subject: Re: performance results on IBM POWER7
Next
From: Robert Haas
Date:
Subject: Re: performance results on IBM POWER7