Re: new GUC var: autovacuum_process_all_tables

On Thu, 2009-02-05 at 17:08 -0500, Tom Lane wrote:
> Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> > On Thu, 2009-02-05 at 16:29 -0500, Tom Lane wrote:
> >> It'd make more sense to put the effort into developing
> >> better scheduling control over autovacuum, such as a concept of
> >> maintenance windows.
>
> > We need that as well, not instead of.
>
> I disagree; adding every frammish anyone could ever think of is not
> an overall improvement to the system.

I like your word frammish and am watchful of such things myself.

> My feeling is that we should be trying to eliminate use-cases for
> cron-driven vacuuming,

Agreed.

> not trying to make sure that cron-driven
> scripts can do anything autovacuum can.

I'm not in favour of limiting our capability to internal actions only.
If we add a capability for scheduling work, we can easily make it
capable of scheduling many kinds of work.

Writing an application maintenance utility in PL/pgSQL is much better
than having to write it for all the different servers an application may
need to run on. We can't ignore that many people use Windows.

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support