Re: Autovacuum cancellation - Mailing list pgsql-patches

From Heikki Linnakangas
Subject Re: Autovacuum cancellation
Date
Msg-id 4721B419.1070700@enterprisedb.com
Whole thread Raw
In response to Autovacuum cancellation  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Autovacuum cancellation
Re: Autovacuum cancellation
List pgsql-patches
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

pgsql-patches by date:

Previous
From: Zdenek Kotala
Date:
Subject: Fix ecpg dependency on postgres.h
Next
From: "Gokulakannan Somasundaram"
Date:
Subject: Re: [HACKERS] Including Snapshot Info with Indexes