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