postgres's idle process remains on BSD

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

Browse pgsql-admin by date

  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