Kevin Brown <blargity@gmail.com> 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