Re: Very long "<IDLE> in transaction" query

From: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org, 'Albe Laurenz' <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Subject: Re: Very long "<IDLE> in transaction" query
Date: 2012-05-04 15:05:53
Message-ID: 20120504150553.GL32303@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, May 04, 2012 at 08:57:08AM -0500, Kevin Grittner wrote:
> "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu> wrote:
>
> > You may also want to consider setting a statement_timeout to
> > prevent this until you can find the problem with the application.
>
> How would a statement timeout help close a transaction on an idle
> connection? It's idle because no statements are being run.
>
> -Kevin

Yes, you are correct. I misunderstood. Too bad we do not have a
transaction_timeout.

Regards,
Ken

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Craig James 2012-05-04 16:57:43 C/C++ Linker Problem in Postgres extension functions
Previous Message Kevin Grittner 2012-05-04 13:57:08 Re: Very long "<IDLE> in transaction" query