pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedlots 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