lots of idle connections open by application

Поиск
Список
Период
Сортировка
От Gourish Singbal
Тема lots of idle connections open by application
Дата
Msg-id 674d1f8a05042503211b0ba14d@mail.gmail.com
обсуждение исходный текст
Ответы Re: lots of idle connections open by application  (lst_hoe01@kwsoft.de)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "dedy"
Дата:
Сообщение: PL/SQL
Следующее
От: lst_hoe01@kwsoft.de
Дата:
Сообщение: Re: lots of idle connections open by application