Re: lots of idle connections open by application

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



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

Предыдущее
От: Gourish Singbal
Дата:
Сообщение: lots of idle connections open by application
Следующее
От: "Simpson"
Дата:
Сообщение: Re: postmaster stop hangs