Josh berkus <josh(at)agliodbs(dot)com> writes:
> Summary: in some cases, "lock pileups" fail to resolve completely, and
> one or more orphan backends are left in permanent lock-waiting state.
> ...
> My attempts to reproduce this issue under synthetic circumstances have
> not been successful. strace of the stuck backends shows no activity.
Please see if you can get a stack trace from a stuck backend.
regards, tom lane