Re: PostgreSQL: Number of waiting connections too high - Mailing list pgsql-admin

From Atul Kumar
Subject Re: PostgreSQL: Number of waiting connections too high
Date
Msg-id CA+ONtZ66PP+RdM+qOfywAH24j=dR-f+zTXAwctCOcABWZ_7yvg@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL: Number of waiting connections too high  (Holger Jakobs <holger@jakobs.com>)
Responses Re: PostgreSQL: Number of waiting connections too high  (Wim Bertels <wim.bertels@ucll.be>)
List pgsql-admin
Hi,

The max_connections are 5000.

but I am getting the alert on mere 500 connections.

Please suggest why is this happening.



Regards,
Atul




On 12/15/20, Holger Jakobs <holger@jakobs.com> wrote:
> Hi,
>
> TCP maintains a backlog of waiting connections if a server application
> doesn't accept or deny connections.
>
> PostgreSQL has a setting max_connections, so it won't accept any more.
>
> So there are two solutions:
>
>   * Lower the number of concurrent clients
>   * Increase the max_connections setting in postgresql.conf
>
> Regards,
>
> Holger
>
> Am 15.12.20 um 10:15 schrieb Atul Kumar:
>> HI,
>>
>> I have postgres with 11.8 version.
>>
>> I am getting below error of
>> PostgreSQL: Number of waiting connections too high.
>>
>> Please help me in solving this situation.
>>
>>
>>
>> Regards,
>> Atul
>>
>>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>



pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: PostgreSQL: Number of waiting connections too high
Next
From: Wim Bertels
Date:
Subject: Re: PostgreSQL: Number of waiting connections too high