Em qua., 11 de mai. de 2022 às 04:18, Sudhir Guna <sudhir.guna...@gmail.com> 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