On 14/08/18 15:26, Don Seiler wrote: > On Tue, Aug 14, 2018 at 8:23 AM, Vick Khera <vi...@khera.org > <mailto:vi...@khera.org>> wrote: > > > The general fix is to never sit idle in transaction, but this > specific case closing the cursor seems like it will also do it. > > > Of course. I've let development know that they need to sort out why it's > left that way.
There is an idle_in_transaction_session_timeout parameter to kill connections that are idle (in transaction) for too long. It was implemented specifically for cases like this. -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
