"Jonah H. Harris" <jonah.harris@xxxxxxxxx> writes: > On Nov 30, 2007 4:30 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> AFAICS we are moving as fast as we can in the direction of auto vacuum >> and analyze. Adding more frammishes to the manual commands seems like >> gilding the buggy whip. > Autovacuum will never be the be all end all. No doubt, which is why no one has proposed removing the manual commands. (Yet, anyway.) But adding complication to them is not going to be an easy sale. We have limited manpower for development and we cannot afford to get bogged down maintaining a codebase with enormous bloat from useless legacy "features". So: show me a use case for this that will still make sense in a mostly-autovacuum world. I can see a need for manual vacuuming of individual special-case tables, but I don't see why schema-wide vacuuming is so useful as to justify diverting development effort to it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
