I am using PostgreSQL 9.5 and we have
max_connections set to
200 in our
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.
- 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.