Clearing out old idle connections

From: Gavin Hamill <gdh(at)laterooms(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Clearing out old idle connections
Date: 2006-05-24 08:02:35
Message-ID: 4474131B.3020809@laterooms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hullo :)

We have pg 8.1.3 and for whatever reason (network blips, poor pooling on
behalf of the client, etc.) we sometimes see a large number (dozens) of
old connections in the idle state which never get reused.

Is there a function in postgres similar to MySQL's 'wait_timeout' which
automatically closes any connections which have been idle for N seconds?
Is this functionality possible to to script/cron by examining the pg
catalogs and finding a 'last used' timestamp?

I am aware the correct response is 'deal with the cause, not the
symptoms', however I assure you that this academic approach wins no
friends in the enterprise market that postgres pitches itself at :)

Cheers,
Gavin.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Velevitch 2006-05-24 08:19:03 How to estimate disk space
Previous Message Harald Armin Massa 2006-05-24 07:36:57 challenging constraint situation - how do I make it real in SQL?