Re: auto-vacuum conflicting with long running analyze

Shane Ambler wrote:

> Given that the analyze will obviously take a long time, is this scenario  
> likely to happen with 8.3.1? or has it been fixed since 8.1.x?

In 8.3, autovacuum cancels itself if it sees it is conflicting with
another query.

> Would this be the issue fixed in 8.1.1? -
> Prevent autovacuum from crashing during ANALYZE of expression index

Unrelated.

> Or is it in various autovacuum improvements from 8.3.0 ?

Yes.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support