Re: idle_in_transaction_timeout - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: idle_in_transaction_timeout
Date
Msg-id 53A9B495.6000500@dalibo.com
Whole thread Raw
In response to Re: idle_in_transaction_timeout  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 06/24/2014 07:17 PM, Tom Lane wrote:
> BTW, has anyone thought about the interaction of this feature with
> prepared transactions?  I wonder whether there shouldn't be a similar but
> separately-settable maximum time for a transaction to stay in the prepared
> state.  If we could set a nonzero default on that, perhaps on the order of
> a few minutes, we could solve the ancient bugaboo that "prepared
> transactions are too dangerous to enable by default".

I did not think about that, but I could probably cook up a patch for it.I don't believe it belongs in this patch,
though.
-- 
Vik



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Atomics hardware support table & supported architectures
Next
From: Noah Misch
Date:
Subject: Re: Atomics hardware support table & supported architectures