From: Justin Pryzby <pryzby@telsasoft.com>
To: Sudhir Guna <sudhir.guna.sg@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: DB connection issue suggestions
Date: Wed, 11 May 2022 14:09:12 -0500
Message-ID: <20220511190911.GO19626@telsasoft.com> (raw)
In-Reply-To: <CAGedWvMr1duwgbb5EshaFn8n71Nn_gd_c0QWEOTx-atHptA+cg@mail.gmail.com>
References: <CAGedWvP=Mho1ayhmpXVQbaS3xxqu9ZgQOhKe-rF4kyxo=gYN0Q@mail.gmail.com>
<20220510181540.GC19626@telsasoft.com>
<CAGedWvMr1duwgbb5EshaFn8n71Nn_gd_c0QWEOTx-atHptA+cg@mail.gmail.com>
On Wed, May 11, 2022 at 09:52:10AM +0800, Sudhir Guna wrote:
> Hi Justin,
>
> Thank you for reviewing.
>
> I have tried to run the below query and could see only less than 5
> connections active when I get this error. The total rows I see is only 10
> including idle and active sessions for this output.
That doesn't sound right. Are you sure you're connecting to the correct
instance ? Are there really only 5 postgres processes on the server, and fewer
than 5 connections to its network port or socket ?
You didn't provide any other info like what OS this is.
--
Justin
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-performance@postgresql.org
Cc: pryzby@telsasoft.com, sudhir.guna.sg@gmail.com
Subject: Re: DB connection issue suggestions
In-Reply-To: <20220511190911.GO19626@telsasoft.com>
* 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