From: Andrew McMillan <andrew@catalyst.net.nz>
To: Gary Hoffman <ghoffman@ucsd.edu>
Cc: pgsql-php@postgresql.org
Subject: Re: Unwanted persisting connections
Date: Mon, 21 Nov 2005 21:58:40 +1300
Message-ID: <1132563520.5795.4.camel@ubu.mcmillan.net.nz> (raw)
In-Reply-To: <fc.00249f0e0172a6d63b9aca00edb8008f.172a744@irpsmail.ucsd.edu>
References: <3DF94EB5-4391-4709-9695-B544F77C5596@myrealbox.com>
<fc.00249f0e0172a6d63b9aca00edb8008f.172a744@irpsmail.ucsd.edu>
On Sun, 2005-11-20 at 20:06 -0800, Gary Hoffman wrote:
> I've run PHP and PostgreSQL for quite a while and never seen this problem
> before. I think it's new, but maybe I never paid attention to it before.
>
> I am frequently running out of connections to the database. Here's a
> snippet of my ps -ax
>
> 1882 ?? S 0:00.07 postgres: postgres cgssd_members [local] idle
>
> 1883 ?? S 0:00.09 postgres: postgres cgssd_members [local] idle
>
> 1884 ?? S 0:00.07 postgres: postgres cgssd_members [local] idle
>
> 1886 ?? S 0:00.14 postgres: postgres cgssd_members [local] idle
>
> 1887 ?? S 0:00.06 postgres: postgres cgssd_members [local] idle
>
> 500 std- S 0:01.14 /usr/local/bin/postmaster -D
> /usr/local/pgsql/data
> 501 std- S 0:00.02 postgres: stats buffer process
>
> 502 std- S 0:00.21 postgres: stats collector process
>
>
> As you can see, there are some idle connections that have come in from PHP
> on my web pages. I've never seen these before and eventually they build up
> and I get an error connecting from the PHP page to the database.
>
> I'm running Apache 1.3.33 on Darwin Kernal 7.9.0 (MacOS X 10.3.9) with PHP
> 4.3.6 and PostgreSQL 7.4.2.
You will have as many of these as you have apache processes. That's
what persistent connections means!
If you have MaxClients set to (e.g.) 150 in your Apache configuration,
and you actually get to something like that, then the default PostgreSQL
configuration of 100 clients simply won't be enough. You should
increase it to at leas 20-50 more than the MaxClients setting that
Apache has.
You'll be pleased to know that each extra PostgreSQL connection
typically uses less than each additional Apache connection (especially
when you're running PHP et al.) so if you find yourself running out of
RAM you will need to lower the MaxClients setting first.
Regards,
Andrew McMillan.
-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803-2201 MOB: +64(272)DEBIAN OFFICE: +64(4)499-2267
You will be a winner today. Pick a fight with a four-year-old.
-------------------------------------------------------------------------
Attachments:
signature.asc (application/pgp-signature, 188B) download
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: andrew@catalyst.net.nz, ghoffman@ucsd.edu
Subject: Re: Unwanted persisting connections
In-Reply-To: <1132563520.5795.4.camel@ubu.mcmillan.net.nz>
References: <3DF94EB5-4391-4709-9695-B544F77C5596@myrealbox.com> <fc.00249f0e0172a6d63b9aca00edb8008f.172a744@irpsmail.ucsd.edu> <1132563520.5795.4.camel@ubu.mcmillan.net.nz>
* 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