Re: Autovacuum cancellation

Alvaro Herrera wrote:
> /*
>  * Look for a blocking autovacuum. There will only ever
>  * be one, since the autovacuum workers are careful
>  * not to operate concurrently on the same table.
>  */

I think that's a bit unaccurate. You could have multiple autovacuum
workers operating on different tables participating in a deadlock. The
reason that can't happen is that autovacuum never holds a lock while
waiting for another.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com