> On Jun 24, 2020, at 6:47 AM, Peter J. Holzer wrote:
>
> The default is 100. What was your reason for reducing it to such a low
> value?
“PostgreSQL 9 High Availability” recommended core count * 3.
>
>> I’ve installed pg_stat_activity and pg_stat_statements.
>>
>> I access this server th
> On Jun 23, 2020, at 8:09 PM, Tim Cross wrote:
>
> Sounds like your web app may not be closing connections once it has
> finished with them? The fact your seeing idle connections would seem to
> support this. I would be verifying there isn't a code path in your
> client application which is fa
>
> On Jun 23, 2020, at 4:51 PM, Michael Lewis wrote:
>
> Do you see anything in pg_stat_activity that stays idle for a while and then
> *does* disappear on its own? Perhaps some types of connections are doing
> client side/application stuff before telling the DB to close the connection.
I’m
I have an issue with a server (v10) that’s seeing increasing connections until
it’s maxxed-out.
max_connections for my 4-core server is set to 12.
I’ve installed pg_stat_activity and pg_stat_statements.
I access this server through a web app, and another client on two machines. I
also sen
