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