Re: apparent deadlock

On 18/11/08 Scott Marlowe did say:
> Just because you've got a blocking transaction doesn't mean it's a
> deadlock.  A deadlock means you have two transactions, each of which
> is waiting for the other to continue before it can go on.  If one
> query is holding up another query, but not vice versa, it's not a
> deadlock, just a lock.

Right you are.

> First place to start is the view pg_locks

I found this:

http://fishbowl.pastiche.org/2004/02/26/finding_open_locks_on_postgresql/

it revealed where the locks were consumed.

Thanks,
Mike
--
Michael P. Soulier <michael_soulier@mitel.com>, 613-592-2122 x2522
"Any intelligent fool can make things bigger and more complex... It takes a
touch of genius - and a lot of courage to move in the opposite direction."
--Albert Einstein