From: Wim Bertels <wim.bertels@ucll.be>
To: Atul Kumar <akumar14871@gmail.com>
To: Holger Jakobs <holger@jakobs.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL: Number of waiting connections too high
Date: Tue, 15 Dec 2020 10:48:13 +0100
Message-ID: <341f1b4fd5f3353e14abf610ba676e7fe1700cbe.camel@ucll.be> (raw)
In-Reply-To: <CA+ONtZ66PP+RdM+qOfywAH24j=dR-f+zTXAwctCOcABWZ_7yvg@mail.gmail.com>
References: <CA+ONtZ7cOEttG_kKZDK4rh6E_vo392dEXpEd6Au=Z9_RxEaHvg@mail.gmail.com>
<cbc3cbd2-0119-1b50-8a2d-bbddecf88fef@jakobs.com>
<CA+ONtZ66PP+RdM+qOfywAH24j=dR-f+zTXAwctCOcABWZ_7yvg@mail.gmail.com>
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/Repli...> 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
> >
> >
--
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"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: wim.bertels@ucll.be, akumar14871@gmail.com, holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL: Number of waiting connections too high
In-Reply-To: <341f1b4fd5f3353e14abf610ba676e7fe1700cbe.camel@ucll.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox