From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Enhancement request
Date: Wed, 5 Dec 2007 13:36:58 -0300
Message-ID: <20071205163658.GE16991@alvh.no-ip.org> (raw)
In-Reply-To: <4756CB9B.3050301@commandprompt.com>
References: <09fbbcab762fc5279e45349ce1cbad93@biglumber.com>
<4756CB9B.3050301@commandprompt.com>
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!"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@alvh.no-ip.org, jd@commandprompt.com, greg@turnstep.com
Subject: Re: Enhancement request
In-Reply-To: <20071205163658.GE16991@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox