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
- Do I need to be concerned with the IDLE connections and will this affect any new tests I run?
- 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.