Too much postmaster prozesses / CPU near 100% - Mailing list pgsql-novice

From Roth, Michael J.
Subject Too much postmaster prozesses / CPU near 100%
Date
Msg-id C35FA50F3392D5119B450002A551B7AD048B00@OFFICE-F2
Whole thread Raw
Responses Re: Too much postmaster prozesses / CPU near 100%
List pgsql-novice

Hi,

first excuse my bad english (my german is better :) ).

we're running a Linux RedHat7.1, Kernel 2.4.2, Postgres 7.1.3,
Apache 1.3.19, PHP 4.0.4
Machine is Dual-Prozessor 2xIntel PIII-900+, 1GB RAM
Connection-Type via php = pconnect

We have a bad performance problem and hope, anybody has a
solution.

If 2 users connects the postmaster forks 30 (!!)
processes, and they do never die.
If 50 Users connects, over 300 postmaster-processes running
and the CPU-States are nearly 100%, so we must stop and
start the postmaster or reboot the server.

IMHO i think, if we use persistant connections, only 1
process per user should be running.

What's wrong here ?

--
Computers are like airconditioners: They stop
working properly if you open windows.
----------------------------------------------------
Michael J. Roth     mailto:MichaelRoth@schmuecker.de
Tel: 069/57005-421, Fax: 069/57005-800
Schmücker&Partner GmbH      http://www.schmuecker.de
Lurgiallee 14, 60539 Frankfurt           
----------------------------------------------------

pgsql-novice by date:

Previous
From: "postgresql"
Date:
Subject: Re: Visual Database Design Tools
Next
From: "Luca Carrettin"
Date:
Subject: