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
Last activity: Nov 15, 2023, 04:09 AM