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
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 |
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 |