Re: [GENERAL] determine database and tables from deadlock

2011-05-30 Thread Craig Ringer
On 05/30/2011 03:45 PM, Machiel Richards wrote: I am however not sure how to trace these back to a database, table, and maybe even a query to determine where things are going wrong. One of the deadlocking queries is shown in the deadlock error message, but one isn't really enough. IIRC, new

[GENERAL] determine database and tables from deadlock

2011-05-30 Thread Machiel Richards
Hi Everyone Some of our databases have been experiencing a sudden spike in deadlocks being detected. as far as our knowledge is concerned, there have not been any new code taken live and no changes from what are aware off. The databases are running postgresql 8.1 From the log