Re: DB connection issue suggestions

Поиск

Список

Период

Сортировка

От	Ranier Vilela
Тема	Re: DB connection issue suggestions
Дата	11 мая 2022 г. 14:45:04
Msg-id	CAEudQAp9GWMFB2O9fP8oSL9xd4EVfFh6Yk+d83XqMJ0AZWH+pg@mail.gmail.com обсуждение исходный текст
Ответ на	Re: DB connection issue suggestions (Sudhir Guna <sudhir.guna.sg@gmail.com>)
Список	pgsql-performance

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 по дате отправления:

От: Sudhir Guna
Дата: 11 мая 2022 г., 10:11:53
Сообщение: Re: DB connection issue suggestions

От: Justin Pryzby
Дата: 11 мая 2022 г., 22:09:12
Сообщение: Re: DB connection issue suggestions