> -----Original Message----- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@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? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
