Re: Autovacuum Improvements

On Thu, 2006-12-21 at 18:41, Alvaro Herrera wrote:
> > From all the discussion here I think the most benefit would result from
> > a means to assign tables to different categories, and set up separate
> > autovacuum rules per category (be it time window when vacuuming is
> > allowed, autovacuum processes assigned, cost settings, etc). I doubt you
> > can really define upfront all the vacuum strategies you would need in
> > real life, so why not let the user define it ? Define the categories by
> > assigning tables to them, and the rules per category. Then you can
> > decide what rules to implement, and what should be the defaults...
>
> Hmm, yeah, I think this is more or less what I have in mind.

Cool :-)

Can I suggest to also consider the idea of some kind of autovacuum
process group, with settings like:

 - number of processes running in parallel;
 - time windows when they are allowed to run;

Then have the table categories with all the rest of the
threshold/cost/delay settings.

Then have the possibility to assign tables to categories, and to assign
categories to processing groups.

I think this would allow the most flexibility with the minimum of
repetition in settings (from the user perspective).

Cheers,
Csaba.