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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to