Postgres Pro
Downloads
Home   >   mailing lists

Idle In Transaction Session Timeout, revived - Mailing list pgsql-hackers

From Vik Fearing
Subject Idle In Transaction Session Timeout, revived
Date
Msg-id 56AE0D10.6060805@2ndquadrant.fr
Whole thread Raw
Responses Re: Idle In Transaction Session Timeout, revived  (Robert Haas <robertmhaas@gmail.com>)
Re: Idle In Transaction Session Timeout, revived  (Fujii Masao <masao.fujii@gmail.com>)
Re: [Reveiw] Idle In Transaction Session Timeout, revived  (Stéphane Schildknecht<stephane.schildknecht@postgres.fr>)
Re: Idle In Transaction Session Timeout, revived  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
Attached is a rebased and revised version of my
idle_in_transaction_session_timeout patch from last year.

This version does not suffer the problems the old one did where it would
jump out of SSL code thanks to Andres' patch in commit
4f85fde8eb860f263384fffdca660e16e77c7f76.

The basic idea is if a session remains idle in a transaction for longer
than the configured time, that connection will be dropped thus releasing
the connection slot and any locks that may have been held by the broken
client.

Added to the March commitfest.
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support
Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: On columnar storage (2)
Next
From: Konstantin Knizhnik
Date:
Subject: Re: PATCH: index-only scans with partial indexes