From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Enhancement request |
Date: | 2007-12-05 16:36:58 |
Message-ID: | 20071205163658.GE16991@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Joshua D. Drake wrote:
> Greg Sabino Mullane wrote:
>> I am curious however, as to what the future vision of autovacuum is.
>> Will it be so efficient that it won't impact all but the busiest tables?
>> Will it be able to figure out the best time to vacuum on its own?
>
> I believe maintenance windows are on the horizon. Of course it seems that
> instead of focusing on that, we should just put in a generic job manager.
When I proposed my idea of maintenance window, everybody seemed happy,
so that's what got implemented.
If you want to propose a generic job manager, be my guest.
>> Will it stop itself mid-run if the need arises?
>
> Man I would love this one... coupled with a just enough vacuum. E.g; it
> calculates a percentage it needs to vacuum, and only vacuums that much.
> Leaving dead tuples behind.
Stop dreaming and start assigning resources for it to get done ;-) The
NTT guys have done so and they are ahead of us on that camp.
--
Alvaro Herrera Developer, http://www.PostgreSQL.org/
"In Europe they call me Niklaus Wirth; in the US they call me Nickel's worth.
That's because in Europe they call me by name, and in the US by value!"
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-12-05 16:38:28 | Re: Enhancement request |
Previous Message | Joshua D. Drake | 2007-12-05 16:02:35 | Re: Enhancement request |