Horton

Re: Autovacuum cancellation

Heikki Linnakangas <heikki@enterprisedb.com>

View thread View on postgr.es
From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-patches@postgresql.org
Date: 2007-10-26T09:32:09Z
Lists: pgsql-hackers 
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