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