Re: How to prevent vacuum and reindex from deadlocking.

Robert Creager <Robert_Creager@LogicalChaos.org> writes:
> Opps, if it helps, the log of the deadlock:

> Aug 10 14:19:36 thunder postgres[18735]: [2-1] ERROR:  deadlock detected

> Aug 10 14:19:36 thunder postgres[18735]: [2-2] DETAIL:  Proc 18735 waits
> for AccessExclusiveLock on relation 18028 of database 17140; blocked by
> proc 18815.

> Aug 10 14:19:36 thunder postgres[18735]: [2-3] Proc 18815 waits for
> AccessExclusiveLock on relation 18101 of database 17140; blocked by proc
> 18735.

What tables do the two referenced OIDs correspond to?  Also, which
process was doing what, exactly?

            regards, tom lane