> 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,
Pennsylvania19026
