| 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: | Whole Thread | Raw Message | 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 |