I was creating a Dashboard in Pentaho PUC which uses a postgres connection as the data source. Most of the time this causes the postgres to say
Too many clients already in Postgres'
SHOW max_connections;
Query shows maximum connections of 200
I used this query select * from pg_stat_activity;
. From that 90% of connections are from the Pentaho server to the database I use as the datasource in my new dashboard. waiting
is f
and state
is idle
in most of the connections. This looks like Pentaho is creating too many connections. How can I limit or Control it? I have already tried increasing connection limit from default 100 to 200 from postgres side but still the issue is there.