Subject: [EXTERNAL] Re: too many clients already
"Abraham, Danny" writes:
> Well, I guess the questions is - how do I optimize PG for a stream of very
> short life checks...
You should be using a connection pooler for a load like that.
PG backends are fairly heavyweight things --- y
"Abraham, Danny" writes:
> Well, I guess the questions is - how do I optimize PG for a stream of very
> short life checks...
You should be using a connection pooler for a load like that.
PG backends are fairly heavyweight things --- you don't want
to fire one up for just a single query, at least
:37.014 CDTLOG: connection received: host=10.64.72.157
port=45813
2020-04-02 11:05:37.018 CDTFATAL: sorry, too many clients already
2020-04-02 11:05:37.015 CDTLOG: connection received: host=10.64.72.157
port=45815
2020-04-02 11:05:37.015 CDTLOG: connection received: host=10.64.72.157
port=45817
"Abraham, Danny" writes:
> 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_connecti
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;
: Abraham, Danny ; pgsql-gene...@postgresql.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
Big installation: max_connections is 1200, shared_buffers is 2GB
-Original Message-
From: Adrian Klaver
Sent: Thursday, April 02, 2020 6:30 PM
To: Abraham, Danny ; pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: too many clients already
On 4/2/20 8:22 AM, Abraham, Danny wrote
how max_connections;
-Original Message-
From: Rob Sargent
Sent: Thursday, April 02, 2020 6:10 PM
To: Abraham, Danny
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: too many clients already
On Apr 2, 2020, at 9:06 AM, Abraham, Danny wrote:
Hi,
Will appreciate a hint here.
Runn
ene...@postgresql.org
Subject: [EXTERNAL] Re: too many clients already
> On Apr 2, 2020, at 9:06 AM, Abraham, Danny wrote:
>
> Hi,
>
> Will appreciate a hint here.
>
> Running on a big and stressed AIX platform and receiving lots of "CDTFATAL:
> sorry, too many
On 4/2/20 8:06 AM, Abraham, Danny 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 in
> On Apr 2, 2020, at 9:06 AM, Abraham, Danny 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.
&g
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_
12 matches
Mail list logo
