Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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... ?

Gourish Singbal


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group