Re: Enhancement request - Mailing list pgsql-admin

From Tom Lane
Subject Re: Enhancement request
Date
Msg-id 7341.1196459304@sss.pgh.pa.us
Whole thread Raw
In response to Re: Enhancement request  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: Enhancement request
List pgsql-admin
"Jonah H. Harris" <jonah.harris@gmail.com> writes:
> On Nov 30, 2007 4:30 PM, Tom Lane <tgl@sss.pgh.pa.us> 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

pgsql-admin by date:

Previous
From: "Usama Dar"
Date:
Subject: Re: Enhancement request
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Enhancement request