From: | Didier Bretin <dbr(at)informactis(dot)com> |
---|---|
To: | pgsql-jdbcMl <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | to much process |
Date: | 2001-01-29 09:02:30 |
Message-ID: | Pine.LNX.4.21.0101290953320.10083-100000@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.1 admintp 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.1 admintp 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.1 admintp 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(at)informactis(dot)com |
/V\ |-----------------------| www.informactis.com |
// \\ | `------------------------|
/( )\ | Visit: http://www.multimania.com/cieexcalibur/ |
^^-^^ `------------------------------------------------'
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Francois Burdet | 2001-01-29 11:11:14 | jdbc: v7.1 bug (letter accent) |
Previous Message | Jeff Duffy | 2001-01-28 05:36:11 | org.postgresql.Serialize |