Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> writes:
> I'm running this query when I'm the only user and this should be the
> only thing running.
> And I get
> DETAIL: Process 7188 waits for ShareLock on transaction 110562621;
> blocked by process 7244. Process 7244 waits for ShareLock on
> transaction 110562544; blocked by process 7188.
It's pretty hard to believe that you haven't got two processes ...
maybe there's something using dblink down in there somewhere?
Also, if you're using a recent PG release, the postmaster log should
contain additional information about the deadlock, like the specific
queries involved on both sides.
regards, tom lane