| From: | "Richard Huxton" <dev(at)archonet(dot)com> |
|---|---|
| To: | "Emmanuel Pierre" <epierre(at)apr-job(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: number of pgsql childrens |
| Date: | 2001-02-20 16:41:59 |
| Message-ID: | 002001c09b5d$722ba2a0$1001a8c0@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
From: "Emmanuel Pierre" <epierre(at)apr-job(dot)com>
> on my DB server I ave 245 "idle" postmasters process for 130 httpd
> persistant DB connections alive.
Are you using persistant connections from Apache/PHP? If so, you are
probably getting at least one connection per Apache child process.
> can anyone give me a clue how to manage this number of unused/idles
> children and how to have them quickerly deallocated ?
If this is Apache, you'll need to make sure the Apache processes die off
quicker. Perhaps look at MaxSpareServers.
- Richard Huxton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2001-02-20 16:50:09 | Re: win2000: problems starting postmaster |
| Previous Message | Bill Barnes | 2001-02-20 16:40:17 | Re: A How-To: PostgreSQL from Tcl via ODBC |