From: Joshua D. Drake <jd@commandprompt.com>
To: Greg Sabino Mullane <greg@turnstep.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Enhancement request
Date: Wed, 05 Dec 2007 08:02:35 -0800
Message-ID: <4756CB9B.3050301@commandprompt.com> (raw)
In-Reply-To: <09fbbcab762fc5279e45349ce1cbad93@biglumber.com>
References: <09fbbcab762fc5279e45349ce1cbad93@biglumber.com>
Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
> 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.
> 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.
Joshua D. Drake
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: jd@commandprompt.com, greg@turnstep.com
Subject: Re: Enhancement request
In-Reply-To: <4756CB9B.3050301@commandprompt.com>
* 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