lots of idle connections open by application

From: Gourish Singbal <gourish(at)gmail(dot)com>
To: PgSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: lots of idle connections open by application
Date: 2005-04-25 10:21:15
Message-ID: 674d1f8a05042503211b0ba14d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi guys,

We have an application using db-conection pooling through resin 2.1
connecting to postgresql 7.4.5 database We have seen that after some
time many connections are kept open in idle state. Sometimes the
connections reach the max_connections = 100 and hence no more clients
can connect to the database.

Guys, Whats a reasonable solution to this problem... ?

--
Best,
Gourish Singbal

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message lst_hoe01 2005-04-25 10:52:09 Re: lots of idle connections open by application
Previous Message bernd.lentes 2005-04-25 08:35:40 Suse 9.2 stops booting while starting the postgres-server