Wow!
Are you sure no one else is going against your database using persistent connections?
How many database handles are you using in your mod_perl apps? Each Apache child
process will require one persistent connection to your database for each different
database handle.
If you have a database server that contains multiple databases, and you're accessing 2
different databases on the same server with your mod_perl/DBI/Apache-DBI apps, you're
going to have double the number of persistent connections to your databases then
you're going to have child processes.
Additionally, if you use one database handle for normal interaction, and another
database handle for transactions [to prevent committing a transaction across tables
until all have been updated] you're going to end up with 1 persistent connection to
your postgresql database for each DBI database handle, even though they are accessing
the same database. I think... :)
Emmanuel Pierre wrote:
>
> Hi all,
>
> on my DB server I have 245 "idle" postmasters process for 130 httpd
> persistant DB connections alive.
>
> can anyone give me a clue how to manage this number of
> unused/idleschildren and how to have them quickerly deallocated ?
>
> this way, I jumptoo quick on 'too much connection'...
>
> Emmanuel
>
> --
> EDENJOB / APR-Job
>
> Email: [EMAIL PROTECTED] 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.
>
> ******************************************************************
--
***NOTE***
This entire message is confidential, and protected by copyright. If you are not the
intended recipient, you are hereby notified that any review, dissemination or
archiving of this message is strictly prohibited.
**********
www.RentZone.org
