Re: too many clients already

On 4/2/20 8:22 AM, Abraham, Danny wrote:
> 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..

Hmm. In psql on the cluster in question what does below return?:

show max_connections;

>
> -----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)?
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com