Re: CPU bound at 99% - Mailing list pgsql-performance

From Ivan Voras
Subject Re: CPU bound at 99%
Date
Msg-id fulu3p$t1q$1@ger.gmane.org
Whole thread Raw
In response to Re: CPU bound at 99%  (Bryan Buecking <buecking@gmail.com>)
List 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 by date:

Previous
From: Ivan Voras
Date:
Subject: Re: Suspicious top output
Next
From: "Merlin Moncure"
Date:
Subject: Re: connections slowing everything down?