Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Luca CarrettinDate: 2001-10-26 16:28:26
Subject:
Previous:From: postgresqlDate: 2001-10-26 11:39:09
Subject: Re: Visual Database Design Tools

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group