Re: PostgreSQL: Number of waiting connections too high

Atul Kumar schreef op di 15-12-2020 om 15:03 [+0530]:
> Hi,
>
> The max_connections are 5000.
>
> but I am getting the alert on mere 500 connections.

have a look a connection pooling Atulor
https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serverhttps://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
> 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
> >
> >
--
mvg,
Wim Bertels
--
https://coronalert.be

Lector
UC Leuven-Limburg
--
Consider well the proportions of things. It is better to be a young June-bug
than an old bird of paradise.
-- Mark Twain, "Pudd'nhead Wilson's Calendar"