Re: connections slowing everything down?

Поиск
Список
Период
Сортировка
От Adrian Moisey
Тема Re: connections slowing everything down?
Дата
Msg-id 480CA18E.3090309@careerjunction.co.za
обсуждение исходный текст
Ответ на Re: connections slowing everything down?  (Erik Jones <erik@myemma.com>)
Ответы Re: connections slowing everything down?  (Erik Jones <erik@myemma.com>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Erik Jones
Дата:
Сообщение: Re: connections slowing everything down?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance of the Materialize operator in a query plan