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
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 |