Heikki Linnakangas <[EMAIL PROTECTED]> writes: > 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. And that's not true either. It may only want low-grade locks (eg AccessShareLock on a system catalog) but deadlock is nonetheless entirely possible in principle. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq