Tom Lane wrote: > If that's the right diagnosis, we probably ought to try to fix DROP > INDEX to not do that, since it could deadlock against any number of > things not just autovac. But there's another question here: can we > make autovac lose the deadlock war, instead of the user process?
Hmm, I thought autovacuum was already supposed to lose on deadlock. Perhaps it's only considering VACUUM though and not analyze ... [checks] nope, that doesn't seem to be it. -- 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
