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