Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group