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

Поиск
Список
Период
Сортировка
От Jehan-Guillaume (ioguix) de Rorthais
Тема Allowing multi "-t" and adding "-n" to vacuumdb ?
Дата
Msg-id 4F4FA59E.7090503@dalibo.com
обсуждение исходный текст
Ответы Re: Allowing multi "-t" and adding "-n" to vacuumdb ?
Список 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 по дате отправления:

Предыдущее
От: Ants Aasma
Дата:
Сообщение: Re: performance results on IBM POWER7
Следующее
От: Robert Haas
Дата:
Сообщение: Re: performance results on IBM POWER7