Re: CPU bound at 99%

Поиск
Список
Период
Сортировка
От Ivan Voras
Тема Re: CPU bound at 99%
Дата
Msg-id fulu3p$t1q$1@ger.gmane.org
обсуждение исходный текст
Ответ на Re: CPU bound at 99%  (Bryan Buecking <buecking@gmail.com>)
Список pgsql-performance
Bryan Buecking wrote:
> On Tue, Apr 22, 2008 at 10:55:19AM -0500, Erik Jones wrote:
>> Are you referring to PHP's persistent connections?  Do not use those.
>> Here's a thread that details the issues with why not:
>> http://archives.postgresql.org/pgsql-general/2007-08/msg00660.php .
>
> Thanks for that article, very informative and persuasive enough that
> I've turned off persistent connections.

Note that it's not always true - current recommended practice for PHP is
to run it in FastCGI, in which case even though there are hundreds of
Apache processes, there are only few PHP processes with their persistent
database connections (and unused PHP FastCGI servers get killed off
routinely) so you get almost "proper" pooling without the overhead.

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

Предыдущее
От: Ivan Voras
Дата:
Сообщение: Re: Suspicious top output
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: connections slowing everything down?