On Tue, 2007-10-02 at 11:17 -0400, Tom Lane wrote: > In any case, this would still only fix things for pg_restore, and I > remain concerned that people will gripe about autovacuum blocking > locks. The idea of kicking autovac off tables remains probably more > interesting in the long run.
Yes, sounds good. I'd also like to see vacuum_delay_point() do a test against CountActiveBackends() to see if anything else is running. If there all non-autovac processes are idle or waiting, then we should skip the delay point, this time only. That way a VACUUM can go at full speed on an idle system and slow down when people get active again. It will also help when people issue a DDL statement against a table that is currently being vacuumed. I've got a patch worked out to do this. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
