Date: Wed, 5 Dec 2007 13:38:28 -0300
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Enhancement request
Message-ID: <20071205163828.GF16991@alvh.no-ip.org>
References: <10684.1196480658@sss.pgh.pa.us>
	<09fbbcab762fc5279e45349ce1cbad93@biglumber.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <09fbbcab762fc5279e45349ce1cbad93@biglumber.com>
User-Agent: Mutt/1.5.16 (2007-06-11)

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? 

I think so; the guys with the dead space map ideas would know.

> Will it be able to figure out the best time to vacuum on its own?

No -- the admin will still need to configure it, of course.

> Will it stop itself mid-run if the need arises?

That's the idea if we get cancellable vacuum, yes.

-- 
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
Thou shalt study thy libraries and strive not to reinvent them without
cause, that thy code may be short and readable and thy days pleasant
and productive. (7th Commandment for C Programmers)