Re: Autovacuum Improvements

From: Glen Parker <glenebob(at)nwlink(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Autovacuum Improvements
Date: 2006-12-20 01:16:48
Message-ID: 45888F00.7060002@nwlink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> The idea that has been discussed in the past is the concept of
> maintenance windows, that is for any given period of time, you can set
> different vacuum thresholds. So at night you might make the thresholds
> very low so that nearly everything gets vacuumed but during the day you
> might only vacuum when something really needs it. This accomplishes
> what you are asking for in a more general way that can accommodate a
> wide variety of usage patterns.

That really seems like something that, if it's powerful, would also be
very complicated. If the autovacuum system could just call a user
defined function, all the complexity could be dropped back into the
admin's lap (which is fine with me :-).

I am of course ASSuming that it would be simple for autovacuum to call a
function if it exists, or take a default action if it does not...

-Glen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2006-12-20 01:18:19 Re: Autovacuum Improvements
Previous Message Glen Parker 2006-12-20 01:00:12 Re: Autovacuum Improvements

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2006-12-20 01:18:19 Re: Autovacuum Improvements
Previous Message Alvaro Herrera 2006-12-20 01:12:41 Re: psql: core dumped