View Single Post

   
  #1 (permalink)  
Old 04-24-2008, 06:16 PM
Adrian Moisey
 
Posts: n/a
Default connections slowing everything down?

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

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply With Quote