Postgres Pro
Downloads
Home   >   mailing lists

Re: DB connection issue suggestions - Mailing list pgsql-performance

From Ranier Vilela
Subject Re: DB connection issue suggestions
Date
Msg-id CAEudQAp9GWMFB2O9fP8oSL9xd4EVfFh6Yk+d83XqMJ0AZWH+pg@mail.gmail.com
Whole thread Raw
In response to Re: DB connection issue suggestions  (Sudhir Guna <sudhir.guna.sg@gmail.com>)
List pgsql-performance
Tree view
Em qua., 11 de mai. de 2022 às 04:18, Sudhir Guna <sudhir.guna.sg@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

pgsql-performance by date:

Previous
From: Sudhir Guna
Date:
Subject: Re: DB connection issue suggestions
Next
From: Justin Pryzby
Date:
Subject: Re: DB connection issue suggestions