"Peter Koczan" <pjkoczan(at)gmail(dot)com> writes:
> So, it looks like the app polls for async notifies every second. Hopefully
> you can glean some insight from that.
My guess is that some condition causes that to stop happening.
One way to monitor this from outside is to use strace to watch the app.
According to the above you should see a recv() attempt on the libpq
socket every second. I suspect that you won't see any more once the app
gets into the state where the recv-q is backing up. Looking at what
happens around the time of the last recv() might give some clues.
regards, tom lane