connections slowing everything down?

Поиск
Список
Период
Сортировка
От Adrian Moisey
Тема connections slowing everything down?
Дата
Msg-id 480C6367.3000508@careerjunction.co.za
обсуждение исходный текст
Ответы Re: connections slowing everything down?  (Erik Jones <erik@myemma.com>)
Re: connections slowing everything down?  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-performance
Hi

# ps -ef | grep idle | wc -l
87
# ps -ef | grep SELECT | wc -l
5


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?

--
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 по дате отправления:

Предыдущее
От: Luke Lonergan
Дата:
Сообщение: Re: Group by more efficient than distinct?
Следующее
От: Viktor Rosenfeld
Дата:
Сообщение: Performance of the Materialize operator in a query plan