Tom Lane wrote: > I think we shall have to reconsider that patch to turn it on by > default. So far I've seen two categories of failure:
So we turn autovacuum off for regression test instance. > * manual ANALYZE issued by regression tests fails because autovac is > analyzing the same table concurrently. Or we put manual exceptions for the affected tables into pg_autovacuum. > * contrib tests fail in their repeated drop/create database > operations because autovac is connected to that database. (pl tests > presumably have same issue.) I opine that when a database is to be dropped, the connections should be cut. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend