[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] CPU bound at 99%
From:       Ivan Voras <ivoras () geri ! cc ! fer ! hr>
Date:       2008-04-22 23:58:47
Message-ID: fulu3p$t1q$1 () ger ! gmane ! org
[Download RAW message or body]

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.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]