pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
lots of idle connections open by application
2+ messages / 2 participants
[nested] [flat]

* lots of idle connections open by application
@ 2005-04-25 10:21 Gourish Singbal <gourish@gmail.com>
  2005-04-25 10:52 ` Re: lots of idle connections open by application lst_hoe01@kwsoft.de
  0 siblings, 1 reply; 2+ messages in thread

From: Gourish Singbal @ 2005-04-25 10:21 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: lots of idle connections open by application
  2005-04-25 10:21 lots of idle connections open by application Gourish Singbal <gourish@gmail.com>
@ 2005-04-25 10:52 ` lst_hoe01@kwsoft.de
  0 siblings, 0 replies; 2+ messages in thread

From: lst_hoe01@kwsoft.de @ 2005-04-25 10:52 UTC (permalink / raw)
  To: pgsql-admin

Zitat von Gourish Singbal <gourish@gmail.com>:

> 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... ?

PgPool was suggested to me some time ago but i never tried it until now.

See http://pgpool.projects.postgresql.org/


Regards

Andreas





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-04-25 10:52 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-25 10:21 lots of idle connections open by application Gourish Singbal <gourish@gmail.com>
2005-04-25 10:52 ` lst_hoe01@kwsoft.de

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox