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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
