Too much postmaster prozesses / CPU near 100%

From: "Roth, Michael J(dot)" <MichaelRoth(at)schmuecker(dot)de>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Too much postmaster prozesses / CPU near 100%
Date: 2001-10-26 15:31:36
Message-ID: C35FA50F3392D5119B450002A551B7AD048B00@OFFICE-F2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)schmuecker(dot)de
Tel: 069/57005-421, Fax: 069/57005-800
Schmücker&Partner GmbH http://www.schmuecker.de
Lurgiallee 14, 60539 Frankfurt
----------------------------------------------------

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Luca Carrettin 2001-10-26 16:28:26
Previous Message postgresql 2001-10-26 11:39:09 Re: Visual Database Design Tools