Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > connections slo...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 4007 of 4159
Post > Topic >>

connections slowing everything down?

by adrian@[EMAIL PROTECTED] (Adrian Moisey) Apr 21, 2008 at 11:50 AM

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@[EMAIL PROTECTED]
 +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

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




 5 Posts in Topic:
connections slowing everything down?
adrian@[EMAIL PROTECTED]   2008-04-21 11:50:31 
Re: connections slowing everything down?
erik@[EMAIL PROTECTED] (  2008-04-21 09:04:28 
Re: connections slowing everything down?
adrian@[EMAIL PROTECTED]   2008-04-21 16:15:42 
Re: connections slowing everything down?
erik@[EMAIL PROTECTED] (  2008-04-21 09:46:17 
Re: connections slowing everything down?
mmoncure@[EMAIL PROTECTED  2008-04-22 20:46:59 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Wed Jul 9 0:04:37 CDT 2008.