Sample Header Ad - 728x90

Concerned about hitting max_connections with many IDLE State connections

0 votes
1 answer
1948 views
I am using PostgreSQL 9.5 and we have max_connections set to 200 in our postgresql.conf file. We have 2 apps server running java apps which are load balanced. When we run our tests via JMETER, I run pg_stat_activity and I can see there is a lot of IDLE connections with most of the queries called COMMIT. ### Questions 1. Do I need to be concerned with the IDLE connections and will this affect any new tests I run? 2. Could this be an issue with my Java apps not auto_committing? My assumption is that the connections will be re-used, but I am concerned if we run more tests that new connections will spin up and the max_connections of **200** will be hit.
Asked by rdbmsNoob (459 rep)
Feb 25, 2021, 12:15 PM
Last activity: Nov 15, 2023, 04:09 AM