Re: Transaction settings: nowait

On Fri, May 29, 2009 at 10:18 AM, Y W <luckyasser(at)gmail(dot)com> wrote:
> Are you referring to connection settings ? Coz if u do, the closet thing I
> can find for the tcp_keepalive_timeout u're mentioning are the
> tcp_keepalives_idle, tcp_keepalives_interval, and the tcp_keepalives_count.
> And apart from the fact that they're ignored for unix-socket connetions,
> these are for terminating the client connection from the client side and not
> from the server side.

Yes those are what I'm referring to, and they apply to the server side
as well. They only terminate DEAD connections. I.e. the client dies,
and x seconds later the connection is closed on the server and the
backend terminated.

> Otherwise I don't know what are you refering to. I
> want to be able to terminate idle connections from the server side, if there
> was a tcp failure with that client which resulted in an unfinished
> transaction and a locked resource, how can u do that ?

tcp keepalive does that.