"Philippe Lang" <philippe.lang@attiksystem.ch> writes:
> I got a deadlock in my database this morning.
There is no deadlock here. The ungranted rows in pg_locks all point to
the transaction ID 6489299, which belongs to PID 11346, which is this
one:
> 11346 ?? R 236:43.23 postmaster: jlroubaty groupefpdb 172.17.10.14 UPDATE (postgres)
An UPDATE that churns for hours and hours may well represent a bug in
your application (unconstrained join maybe?) but it's not a deadlock.
regards, tom lane