From: | "Abraham, Danny" <danny_abraham(at)bmc(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Cc: | "Abraham, Danny" <danny_abraham(at)bmc(dot)com> |
Subject: | RE: Re: too many clients already |
Date: | 2020-04-02 15:22:00 |
Message-ID: | 489930bf467e463bb79d23c80260e3ac@phx-exmbprd-01.adprod.bmc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
No pg-bouncer or connection pooling.
ps -elf | grep postgres | grep idle | wc -l ==> 61
and BTW: Running, say 500 one command psql in parallel will have the same affect..
-----Original Message-----
From: Rob Sargent <robjsargent(at)gmail(dot)com>
Sent: Thursday, April 02, 2020 6:10 PM
To: Abraham, Danny <danny_abraham(at)bmc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: [EXTERNAL] Re: too many clients already
> On Apr 2, 2020, at 9:06 AM, Abraham, Danny <danny_abraham(at)bmc(dot)com> wrote:
>
> Hi,
>
> Will appreciate a hint here.
>
> Running on a big and stressed AIX platform and receiving lots of "CDTFATAL: sorry, too many clients already"
> and transient difficulty to log in.
>
> Happens on all PG versions (Tested 9.5,10.4,11.5)
>
> Big installation: max_connections is 1200, shared_buffers is 2GB
>
> But .. select count(*) from pg_stat_activity is only 66.
>
> Thanks
>
> Danny
>
>
Lots of idle, kept-alive clients? Do you have a connection pooler (e.g. pg-bouncer)?
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-04-02 15:29:54 | Re: too many clients already |
Previous Message | Adrian Klaver | 2020-04-02 15:20:38 | Re: too many clients already |