Hi
# ps -ef | grep idle | wc -l
87
[...]
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?
Dependant on how much memory you have in your system, yes. You can fix
the constant use of memory by idle connections by adjusting the
child_life_time setting in your pgpool.conf file. The default if 5
minutes which a bit long. Try dropping that down to 20 or 30 seconds.
We have 32GBs. If I get it to close the connections faster, will that
actually help? Is there a way i can figure it out?
--
Adrian Moisey
Systems Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: [EMAIL PROTECTED]
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
