From: Adrian Moisey <adrian@careerjunction.co.za>
To: Erik Jones <erik@myemma.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: connections slowing everything down?
Date: Mon, 21 Apr 2008 16:15:42 +0200
Message-ID: <480CA18E.3090309@careerjunction.co.za> (raw)
In-Reply-To: <C14C8588-A291-47EF-87EC-AD7FECA0DF8D@myemma.com>
References: <480C6367.3000508@careerjunction.co.za>
<C14C8588-A291-47EF-87EC-AD7FECA0DF8D@myemma.com>
Hi
>> # ps -ef | grep idle | wc -l
>> 87
[...]
>> I have 2 web servers which connect to PGPool which connects to our
>> postgres db. I have noticed that idle connections seem to take up CPU
>> and RAM (according to top). Could this in any way cause things to
>> slow down?
>
> Dependant on how much memory you have in your system, yes. You can fix
> the constant use of memory by idle connections by adjusting the
> child_life_time setting in your pgpool.conf file. The default if 5
> minutes which a bit long. Try dropping that down to 20 or 30 seconds.
We have 32GBs. If I get it to close the connections faster, will that
actually help? Is there a way i can figure it out?
--
Adrian Moisey
Systems Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: adrian@careerjunction.co.za, erik@myemma.com
Subject: Re: connections slowing everything down?
In-Reply-To: <480CA18E.3090309@careerjunction.co.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox