Search Postgresql Archives

Re: too many clients already

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

 



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.klaver@xxxxxxxxxxx>
Sent: Thursday, April 02, 2020 6:30 PM
To: Abraham, Danny <danny_abraham@xxxxxxx>; pgsql-general@xxxxxxxxxxxxxx
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@xxxxxxxxx>
Sent: Thursday, April 02, 2020 6:10 PM
To: Abraham, Danny <danny_abraham@xxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: [EXTERNAL] Re: too many clients already



On Apr 2, 2020, at 9:06 AM, Abraham, Danny <danny_abraham@xxxxxxx> 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.klaver@xxxxxxxxxxx





[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 Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux