Re: Enhancement request - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Enhancement request
Date
Msg-id 4756CB9B.3050301@commandprompt.com
Whole thread Raw
In response to Re: Enhancement request  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: Enhancement request  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: "Rodrigo De León"
Date:
Subject: Re: I want to Collect information about postgresql
Next
From: Alvaro Herrera
Date:
Subject: Re: Enhancement request