Re: [HACKERS] Allowing multi -t and adding -n to vacuumdb ?

2012-03-02 Thread Jehan-Guillaume (ioguix) de Rorthais
On 01/03/2012 23:13, Tom Lane wrote: Jehan-Guillaume (ioguix) de Rorthais j...@dalibo.com writes: 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

[HACKERS] Allowing multi -t and adding -n to vacuumdb ?

2012-03-01 Thread Jehan-Guillaume (ioguix) de Rorthais
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

Re: [HACKERS] Allowing multi -t and adding -n to vacuumdb ?

2012-03-01 Thread Tom Lane
Jehan-Guillaume (ioguix) de Rorthais j...@dalibo.com writes: 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

Re: [HACKERS] Allowing multi -t and adding -n to vacuumdb ?

2012-03-01 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: Why isn't your customer using autovacuum? If there are concrete reasons why that doesn't get the job done for him, it would be more useful in the long run to work on fixing that. FWIW, we're using autovacuum here, at slightly more aggressive settings from