Kevin Brown <blargity@xxxxxxxxx> writes: > When the "deadlock" occurs: > kevin@ajbit:~> ps -elF | grep postgres > 1 S postgres 6020 17767 0 75 0 - 10585 - 15136 0 19:57 ? > 00:00:29 postgres: dli dli 127.0.0.1(39869) idle in transaction > 1 S postgres 6195 17767 0 76 0 - 10323 semtim 14940 0 20:22 ? > 00:00:28 postgres: dli dli 127.0.0.1(37735) INSERT waiting > You can see an insert is just waiting. On what? I'd bet it's waiting on the "idle in transaction" transaction, which is waiting for a nonresponding client. But the pg_locks view would tell you more. regards, tom lane
