"henry" <henry@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
