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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
