public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: KK CHN <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Pgbouncer and Node JS application Query read timeout error
Date: Wed, 08 Apr 2026 08:27:59 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKgGyB_OmPnsgrr7YWOY=w8VDH7pN2hCt4Tsd1nJy=-xM=64eA@mail.gmail.com>
References: <CAKgGyB_OmPnsgrr7YWOY=w8VDH7pN2hCt4Tsd1nJy=-xM=64eA@mail.gmail.com>

On Wed, 2026-04-08 at 10:51 +0530, KK CHN wrote:
> List, I am using pgbouncer(PgBouncer 1.23.1 RHEL 9.4) along with  Postgres16(RHEL 9.4)
> for connection pooling.   
> 
> Running a nodejs application which is throwing some errors  related to query timeout
> which the development team suspect after pgbouncer deployment this behaviour appears,
> but not sure 
> 
> The error which is thrown from  the nodejs logs as follows.. 
> 
> [image showing an error "Query read timeout"]
>
> Is this due to   pgbouncer config issues or   nodejs  pool config issues ?
> 
> for  reference here the pgbouncer  config params and  node js  params at present.
> 
> pgbouncer.ini
> 
> [...]
> [pgbouncer]
> pool_mode = transaction
> default_pool_size = 50
> min_pool_size = 30
> reserve_pool_size = 10
> reserve_pool_timeout = 5
> max_db_connections = 130
> max_user_connections = 180
> server_lifetime = 3600
> server_idle_timeout = 600
> [...]


The only way I can imagine that pgBouncer is leading to timeouts on the client side
is if client sessions are waiting, because all connections are in use.

You can run SHOW POOLS in the pgBouncer console to see if there are any "cl_waiting".
If that is the case, you should configure the Node.js pools smaller, so that no
connection has to wait.

Yours,
Laurenz Albe

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Pgbouncer and Node JS application Query read timeout error
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox