connections slowing everything down? - Mailing list pgsql-performance

From Adrian Moisey
Subject connections slowing everything down?
Date
Msg-id 480C6367.3000508@careerjunction.co.za
Whole thread Raw
Responses Re: connections slowing everything down?
Re: connections slowing everything down?
List 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 by date:

Previous
From: Luke Lonergan
Date:
Subject: Re: Group by more efficient than distinct?
Next
From: Viktor Rosenfeld
Date:
Subject: Performance of the Materialize operator in a query plan