> Can you provide more details? pg_locks, pg_stat_activity, the deadlock > message? > > (Hmm, it would be helpful if the deadlock checker were to save the > pg_locks contents and perhaps pg_stat_activity in a file, whenever a > deadlock is detected.) Great idea! As somebody who's spent hours tracking down deadlocks recently, I'd love to have a configurable deadlocks.log file capability. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster