Re: Transaction settings: nowait

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Transaction settings: nowait
Дата
Msg-id dcc563d10905290922wd9bfdcegcd3b3d6f5667143b@mail.gmail.com
обсуждение исходный текст
Ответ на Transaction settings: nowait  (durumdara <durumdara@gmail.com>)
Список pgsql-general
On Fri, May 29, 2009 at 10:18 AM, Y W <luckyasser@gmail.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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Emi Lu
Дата:
Сообщение: Re: How can I look at a recursive table dependency tree?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Converting each item in array to a query result row