Re: Too much postmaster prozesses / CPU near 100%

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Too much postmaster prozesses / CPU near 100%
Дата
Msg-id web-492990@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Too much postmaster prozesses / CPU near 100%  ("Roth, Michael J." <MichaelRoth@schmuecker.de>)
Список pgsql-novice
Michael,

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

It's okay -- my German is terrible, so we're even.

> 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.

There are issues with PHP persistent connections and PostgreSQL which
cause exactly the problem you're having.  They are fixable, but involve
some tradeoffs.

Go to the PGSQL-PHP list archives and comb through them; much of the
discussion for the past year has been about persistent. pooled, and
other connection strategies.  See:
http://archives2.us.postgresql.org/pgsql-php/

You also may wish to join the PGSQL-PHP list, as well as the PGSQL-SQL
list.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: copy command...
Следующее
От: "Brett W. McCoy"
Дата:
Сообщение: Re: copy command...