connections slowing everything down?

From: Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za>
To: pgsql-performance(at)postgresql(dot)org
Subject: connections slowing everything down?
Date: 2008-04-21 09:50:31
Message-ID: 480C6367.3000508@careerjunction.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)careerjunction(dot)co(dot)za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Viktor Rosenfeld 2008-04-21 11:07:22 Performance of the Materialize operator in a query plan
Previous Message Luke Lonergan 2008-04-21 05:35:58 Re: Group by more efficient than distinct?