Re: idle_in_transaction_timeout - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: idle_in_transaction_timeout
Date
Msg-id 53A35856.7070402@agliodbs.com
Whole thread Raw
In response to Re: idle_in_transaction_timeout  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: idle_in_transaction_timeout  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-hackers
On 06/19/2014 10:39 AM, David G Johnston wrote:
> Advocating for the Devil (or a more robust, if probably complicated,
> solution):
> "idle_in_transaction_timeout=10s"
> "idle_in_transaction_target=session|transaction"

Per Kevin Grittner's assessment, aborting the transaction is currently a
nonstarter. So no need for a 2nd GUC.

Also, I really hope that nobody is setting this to 10s ...

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: WIP patch for multiple column assignment in UPDATE
Next
From: Kevin Grittner
Date:
Subject: Re: idle_in_transaction_timeout