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

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

On Mon, Mar 8, 2021 at 9:46 AM Christophe Pettus <xof(at)thebuild(dot)com> wrote:

>
>
> > On Mar 7, 2021, at 17:34, Abdul Qoyyuum <aqoyyuum(at)cardaccess(dot)com(dot)au>
> 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(at)thebuild(dot)com
>
>

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