Em qua., 11 de mai. de 2022 às 04:18, Sudhir Guna <sudhir.guna.sg@xxxxxxxxx> escreveu:
Hi MichaelDBA,Thank you for reviewing.I had validated the show max_connections and its 1000.
I think that you are wasting resources with this configuration.
Try enabling Connection Pool at Pentaho configuration.
And set the
Pool Size (Maximum) to 100 for Pentaho and 100 for Postgres (max_connections).
Under Advanced Options (DataSource Windows) enable Connection Pool.
Probably Pentaho is trying to use more connections than Postgres allows.
regards,
Ranier Vilela
