public inbox for [email protected]  

help / color / mirror / Atom feed

From: [email protected]
To: [email protected]
Subject: About PG-Pool Load balance configuration
Date: Wed, 15 Oct 2025 09:24:33 +0800
Message-ID: <[email protected]> (raw)

Dear pgpool-general,

 

I have already set up a cluster(base streaming replication) with three pgpool service(4.5.2) and three postgres nodes(17.5.2).

Also, I enable load balance mode because we need this.

 

In our config file of pgpool, I also set “statement_level_load_balance” to on and “allow_sql_comments” to off.

Now, I have some queries that I want to control whether I use load balance mode or not.

 

After I checked the documentation, I find out that I can add “/*NO LOAD BALANCE*/” before select query only in pgpool 4.2.

But can not add this comment before select query in pgpool 4.5.

 

https://www.pgpool.net/docs/42/en/html/runtime-config-load-balancing.html (have /*NO LOAD BALANCE*/)

https://www.pgpool.net/docs/45/en/html/runtime-config-load-balancing.html (do not have /*NO LOAD BALANCE*/))

 

Do you have any idea about this?



Best Regards,

Terence

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: About PG-Pool Load balance configuration
  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