From: | "Abraham, Danny" <danny_abraham(at)bmc(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: Re: too many clients already |
Date: | 2020-04-02 15:41:32 |
Message-ID: | 563c66befbd046f7b5b558a6167eca04@phx-exmbprd-01.adprod.bmc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
va-tlv-ctm-qa22.isr.bmc.com% sql
psql: FATAL: sorry, too many clients already
va-tlv-ctm-qa22.isr.bmc.com% sql
psql (11.5)
Type "help" for help.
ctrlmdb=> show max_connections;
max_connections
-----------------
1200
(1 row)
ctrlmdb=> show shared_buffers;
shared_buffers
----------------
2000MB
(1 row)
-----Original Message-----
From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Sent: Thursday, April 02, 2020 6:37 PM
To: Abraham, Danny <danny_abraham(at)bmc(dot)com>; pgsql-general(at)postgresql(dot)org
Subject: [EXTERNAL] Re: too many clients already
On 4/2/20 8:35 AM, Abraham, Danny wrote:
> Big installation: max_connections is 1200, shared_buffers is 2GB
Have you confirmed that the above is actually in effect by doing?:
show max_connections;
>
> -----Original Message-----
> From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> Sent: Thursday, April 02, 2020 6:30 PM
> To: Abraham, Danny <danny_abraham(at)bmc(dot)com>; pgsql-general(at)postgresql(dot)org
> Subject: [EXTERNAL] 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-04-02 15:51:55 | Re: too many clients already |
Previous Message | Adrian Klaver | 2020-04-02 15:37:23 | Re: too many clients already |