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
