"henry" <henry(at)zen(dot)co(dot)za> writes:
> The culprit in my case was a local trigger firing on INSERTs using
> dblink_exec() without 'host=127.0.0.1'. Bad news though, even _with_
> 'host=127.0.0.1' the connections do not idle timeout. They just hang
> around waiting for the rapture.
> So,... this appears to be dblink related after all. I'll be trying
> explicit open/exec/close. Weird that dblink_exec in a trigger doesn't
> release resources.
Hmm, this is the transient-connection form of dblink? If so, that would
be a bug. Can you put together a test case? Also, which PG version are
you using, exactly?
regards, tom lane