| From: | Ivan Voras <ivoras(at)geri(dot)cc(dot)fer(dot)hr> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: CPU bound at 99% |
| Date: | 2008-04-22 23:58:47 |
| Message-ID: | fulu3p$t1q$1@ger.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2008-04-23 00:46:59 | Re: connections slowing everything down? |
| Previous Message | Ivan Voras | 2008-04-22 23:50:33 | Re: Suspicious top output |