Re: trying to make sense of deadlocks

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Richard Yen
> Sent: Monday, February 09, 2009 4:18 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] trying to make sense of deadlocks
>
> Hi,
>
> I'm trying to make sense of a situation I ran into this morning.
> Apparently, there were numerous deadlocks (approx. 75 in a 30-min
> period) while procs were trying to write to a table (16634, "account")
> in my database.
>
> Just to give you a sense of what's going on, process 22583 tried to do
> an insert, followed by an update, and the insert took 225925.724 ms:
>
>
> Might someone be able to help me make more sense of this?
>

The two processes that are conflicting, can you list everything they do
since the beginning of the transaction until the deadlock?