Re: Pgbouncer performance query - Mailing list pgsql-general

From Dominique Devienne
Subject Re: Pgbouncer performance query
Date
Msg-id CAFCRh-8jQSMEz2mfWXbGfu_mMdty2dJbR8uCNdACdeRjDc4s-g@mail.gmail.com
Whole thread Raw
In response to Pgbouncer performance query  (KK CHN <kkchn.in@gmail.com>)
Responses Re: Pgbouncer performance query
List pgsql-general
On Thu, Jan 22, 2026 at 1:29 PM KK CHN <kkchn.in@gmail.com> wrote:
> I agree  when I have increased the concurrent connections to 300   (pgbench -c 300 ) then  Direct hit on DB server
failswith  Error too many clients as follows 

Just increase max_connections then:
https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-MAX-CONNECTIONS

Sounds like you should stick to direct PostgeSQL access, if pgBouncer
makes it 10x slower :). --DD



pgsql-general by date:

Previous
From: KK CHN
Date:
Subject: Pgbouncer performance query
Next
From: Nicolas Seinlet
Date:
Subject: Re: pg_trgm upgrade to 1.6 led to load average increase