From: | Junichi Sako <sako(at)cyphertec(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | postgres's idle process remains on BSD |
Date: | 2003-09-24 06:18:16 |
Message-ID: | 20030924151113.7D3D.SAKO@cyphertec.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear all,
I am running a PostgreSQL 7.3.2 on a FreeBSD. A Tomcat server
connects to it locally by JDBC.
I created a test module which sends a http request to the Tomcat
server to store some data on DB. The test module sends a http
request 5000 times continusly. After sending 5000 requests, a lot
of postgres idle processes remains, and if I send more request to
the server, the postgres stops accepting connection when the
number of postgres processes reaches 127 which is the same number
as postgres's max_connections. The idle processes do not
disappear even two days passed.
Anybody have any idea what is going on?
At the beginning only 3 processes:
99832 p0- S 0:42.80 /usr/local/bin/postmaster (postgres)
99836 p0- S 0:03.71 postmaster: stats buffer process (postgres)
99838 p0- S 0:08.67 postmaster: stats collector process (postgres)
As I acess to the Tomcat server:
18263 p0- I 0:00.01 postmaster: test tdb 127.0.0.1 idle (postgres)
18283 p0- I 0:00.01 postmaster: test tdb 127.0.0.1 idle (postgres)
18445 p0- I 0:00.01 postmaster: test tdb 127.0.0.1 idle (postgres)
these idle processes grow upto 127 processes which is same as
max_connection setting.
The specs:
FreeBSD 5.1-RELEASE-p3
Apache 2.0.47
PostgreSQL 7.3.2
J2SDK 1.4.1p3_3
Jakarta-Tomcat 4.1.27
Thanks for any help,
Jun
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2003-09-24 06:32:32 | Re: [GENERAL] Fatal error: Allowed memory size of 8388608 |
Previous Message | Bruno Wolff III | 2003-09-24 06:14:49 | Re: export data from excel to postges |