Re: [ADMIN] Enhancement request

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)

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match