Re: auto-vacuum conflicting with long running analyze

Alvaro Herrera wrote:
> 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.
> 

Sounds good. When it has run through to verify I will get them to update 
their notes on that.


-- 

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz