to much process

Поиск
Список
Период
Сортировка
От Didier Bretin
Тема to much process
Дата
Msg-id Pine.LNX.4.21.0101290953320.10083-100000@localhost.localdomain
обсуждение исходный текст
Ответы Re: to much process  (Richard Bullington-McGuire <rbulling@microstate.com>)
Re: to much process  (Peter T Mount <peter@retep.org.uk>)
Список pgsql-jdbc
Hello,

  I use postgres with my servlet on a linux box. Sometimes when I do
a 'ps auxf' I saw that I have a lot (about 20) of postgres process like this:
postgres 19025  0.0  0.7 31124  988 ?        SN    2000   4:59 /cassiope/usr/local/postgresql-7.0/bin/postmaster -D
/cassiope/var/pgdata2-p 5430 -i 
postgres 25749  0.0  2.1 31472 2724 ?        SN   09:18   0:00  \_ /cassiope/usr/local/postgresql-7.0/bin/postgres
127.0.0.1admintp truckplus_1 idle   
postgres 26528  0.0  2.3 31680 2976 ?        SN   10:00   0:00  \_ /cassiope/usr/local/postgresql-7.0/bin/postgres
127.0.0.1admintp truckplus_1 idle   
postgres 26663  0.0  2.1 31492 2788 ?        SN   10:09   0:00  \_ /cassiope/usr/local/postgresql-7.0/bin/postgres
127.0.0.1admintp truckplus_1 idle   

And sometimes when the number of process is so big, I can't connect to postgresql with jdbc :o(.
Apparently, the connections opened are not close by the garbage collector ...

Is there a solution to avoid such problem ?

Thanks.
--
            .------------------------------------------------.
    .^.     | Didier Bretin, France | dbr@informactis.com    |
    /V\     |-----------------------| www.informactis.com    |
   // \\    |                       `------------------------|
  /(   )\   | Visit: http://www.multimania.com/cieexcalibur/ |
   ^^-^^    `------------------------------------------------'


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

Предыдущее
От: Jeff Duffy
Дата:
Сообщение: org.postgresql.Serialize
Следующее
От: Richard Bullington-McGuire
Дата:
Сообщение: Re: to much process