From: Ivan Voras <ivoras@geri.cc.fer.hr>
To: pgsql-performance@postgresql.org
Subject: Re: CPU bound at 99%
Date: Wed, 23 Apr 2008 01:58:47 +0200
Message-ID: <fulu3p$t1q$1@ger.gmane.org> (raw)
In-Reply-To: <20080422161637.GF5961@starling-software.com>
References: <20080422153045.GB5961@starling-software.com>
<DCD21583-38AA-4E01-BA29-39A7078259FE@myemma.com>
<20080422161637.GF5961@starling-software.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ivoras@geri.cc.fer.hr
Subject: Re: CPU bound at 99%
In-Reply-To: <fulu3p$t1q$1@ger.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox