public inbox for [email protected]
help / color / mirror / Atom feedFrom: Terence Un <[email protected]>
To: [email protected] <[email protected]>
Subject: About load balance mode in pgpool
Date: Tue, 14 Oct 2025 04:47:12 +0000
Message-ID: <[email protected]> (raw)
Dear pgpool-general,
I have already set up a cluster 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 Un | (853) 8881 4205
數據庫工程師 Database Engineer
資訊科技部 Information Technology Department
Notice: Sociedade de Jogos de Macau S.A. has been renamed to SJM Resorts, S.A. .
通知：澳門博彩股?有限公司已更名為澳?綜合度假股?有限公司。
[cid:GLPE-Banner(Day)_cd5e890e-b11a-49a4-afd9-cd6e4f8052f6.jpg]
Attachments:
[image/jpeg] GLPE-Banner(Day)_cd5e890e-b11a-49a4-afd9-cd6e4f8052f6.jpg (209.9K, 3-GLPE-Banner%28Day%29_cd5e890e-b11a-49a4-afd9-cd6e4f8052f6.jpg)
download | view image
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 load balance mode in pgpool
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