Re: number of pgsql childrens

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: Raw Message | Whole Thread | 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

In response to

Browse pgsql-general by date

  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