Re: pg_autovacuum next steps

On Mon, 2004-03-22 at 07:25, Richard Huxton wrote:
> On Monday 22 March 2004 03:36, Matthew T. O'Connor wrote:
> > 1.Store config data inside a special pg_autovacuum table inside
> > existing databases that wants custom settings.
> >
> > 2.Use a config file. This would require some additional coding to add
> > the required parsing, but is possible.
> >
> > 3.Create a pg_autovacuum database inside any cluster that wants to
> > customize their settings.parsing code. My preference is option 3.
>
> I've nothing against #3 as a default, but can I put in a suggestion for 1 & 3,
> or rather some setting definable at runtime/build-time that lets you select
> database + schema for autovacuum to find its config data.
>
> I might be wrong, but it strikes me as the sort of thing people running shared
> environments will want to choose for themselves.

If pg_autovacuum was being designed to live forever as a client app,
then I agree admins having a choice would be good. But as we are going
to eventually move any auto_vacuum data and settings into the system
tables (when autovacuum is part of the system), I don't see the need to
expend the extra cycles, especially since people seem to be pushing hard
for autovacuum to be a backend function sooner rather than later.