I'm using Postgres 9.2.15 on CentOS 7.2 with the method described below to
support INSERTing from multiple processes:
http://www.postgresql.org/message-id/CAAcYxUf9o3NpiKaHdeShO_iJjm92314eX6ko0JvJidmksutkJg@mail.gmail.com
Last night, one of the processes experienced a dead lock. The error looked
like this:
ERROR: deadlock detected
DETAIL: Process 23527 waits for ShareLock on transaction 1537228819;
blocked by process 34184
Process 34184 waits for ShareLock on transaction 1537228441;
blocked by process 23527.
Is there anything I can do to help diagnose what the cause of this issue
was?
Thanks,
Dave