Re: DB connection issue suggestions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux