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
:05:37.022 CDTFATAL: sorry, too many clients already
2020-04-02 11:05:37.022 CDTFATAL: sorry, too many clients already
-Original Message-
From: Tom Lane
Sent: Thursday, April 02, 2020 6:52 PM
To: Abraham, Danny
Cc: pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: too many clients
"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_connections is 1200, shared_buffers is 2GB
shared_buffers
2000MB
(1 row)
-Original Message-
From: Adrian Klaver
Sent: Thursday, April 02, 2020 6:37 PM
To: Abraham, Danny ; pgsql-gene...@postgresql.org
Subject: [EXTERNAL] Re: too many clients already
On 4/2/20 8:35 AM, Abraham, Danny wrote:
> Big installation: max_
: 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 installation: max_
> 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.
>
> Happens on all PG versions (Tested 9.5,
11 matches
Mail list logo
