Search Postgresql Archives

Re: Is it normal to have too many idle processes in postgresql cluster?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks Christophe! I guess I had nothing to be worried about.

On Mon, Mar 8, 2021 at 9:46 AM Christophe Pettus <xof@xxxxxxxxxxxx> wrote:


> On Mar 7, 2021, at 17:34, Abdul Qoyyuum <aqoyyuum@xxxxxxxxxxxxxxxxx> wrote:
> Seems to get me worried. Should I be worried? Is this normal? If not, what should I do?

It's normal.  Every connected client has an associated backend process, even if the client isn't doing anything.  That's what the "idle" state means.  You can consider using a pooler such as pgbouncer to reduce the number of connections the clients have open, although 200 open connections is nothing concerning.

--
-- Christophe Pettus
   xof@xxxxxxxxxxxx



--
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux