Re: number of pgsql childrens - Mailing list pgsql-general

From Richard Huxton
Subject Re: number of pgsql childrens
Date
Msg-id 002001c09b5d$722ba2a0$1001a8c0@archonet.com
Whole thread Raw
In response to number of pgsql childrens  (Emmanuel Pierre <epierre@apr-job.com>)
List pgsql-general
From: "Emmanuel Pierre" <epierre@apr-job.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


pgsql-general by date:

Previous
From: Konstantinos Agouros
Date:
Subject: -F and perl again
Next
From: newsreader@mediaone.net
Date:
Subject: Re: Installing DBI client