Thread: number of pgsql childrens
on my DB server I ave 245 "idle" postmasters process for 130 httpd persistant DB connections alive. can anyone give me a clue how to manage this number of unused/idles children and how to have them quickerly deallocated ? -- EDENJOB / APR-Job Email: epierre@apr-job.com Home: www.apr-job.com Phone: +33 1 47 81 02 41 Tatoo: +33 6 57 60 42 17 Fax: +33 1 41 92 91 54 eFAX: +44 0870-122-6748 ****************************************************************** This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither EDENJOB/APR-JOB or affiliates shall be liable for the message if altered, changed or falsified. ******************************************************************
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