| From: | Atul Kumar <akumar14871(at)gmail(dot)com> |
|---|---|
| To: | Holger Jakobs <holger(at)jakobs(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PostgreSQL: Number of waiting connections too high |
| Date: | 2020-12-15 09:33:12 |
| Message-ID: | CA+ONtZ66PP+RdM+qOfywAH24j=dR-f+zTXAwctCOcABWZ_7yvg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)jakobs(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wim Bertels | 2020-12-15 09:48:13 | Re: PostgreSQL: Number of waiting connections too high |
| Previous Message | Holger Jakobs | 2020-12-15 09:21:21 | Re: PostgreSQL: Number of waiting connections too high |