Re: [HACKERS] How to get info about deadlocks?

> I've been experimenting with concurrent VACUUMs and getting occasional
> instances of
> 
> NOTICE:  Deadlock detected -- See the lock(l) manual page for a possible cause.
> ERROR:  WaitOnLock: error on wakeup - Aborting this transaction
> 
> It would be really nice if I could find out the particular locks that
> are causing this conflict --- but the code that emits these messages
> isn't very transparent :-(.  Can anyone explain how to determine just
> what the deadlock is?
> 

Massimo has some.  See the top of lock.c for pg_options flags to dump
out locks.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026