Re: Idle connection timeout

Thom Brown escribió:
> 2009/10/9 Bruce Momjian <bruce(at)momjian(dot)us>
>
> > Thom Brown wrote:
> > > I saw a recent blog entry where someone came up with a solution
> > > for expiring idle connections (
> > >
> > http://dividebyzeroexception.blogspot.com/2009/10/implementing-waittimeout-in-postgresql.html
> > )
> > > and I was surprised there wasn't a config option for this already.
> > > Is this something that can be considered for a future release?
> >
> > Our TODO has:
> >
> > Add idle_in_transaction_timeout GUC so locks are not held for
> > long periods of time
>
> Awesome! Thanks for the info Bruce.

This is quite a different thing though. You were talking about idle
connections; the TODO item is about idle-in-transaction connections.
(Also, keep in mind that something being in the TODO list does not mean
anyone is planning to work on it.)

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support