From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Enhancement request
Date: Wed, 5 Dec 2007 13:38:28 -0300
Message-ID: <20071205163828.GF16991@alvh.no-ip.org> (raw)
In-Reply-To: <09fbbcab762fc5279e45349ce1cbad93@biglumber.com>
References: <10684.1196480658@sss.pgh.pa.us>
<09fbbcab762fc5279e45349ce1cbad93@biglumber.com>
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)
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, greg@turnstep.com
Subject: Re: Enhancement request
In-Reply-To: <20071205163828.GF16991@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