From: | Terence Un <terenceun(at)sjmresorts(dot)com> |
---|---|
To: | "pgpool-general(at)lists(dot)postgresql(dot)org" <pgpool-general(at)lists(dot)postgresql(dot)org> |
Subject: | About load balance mode in pgpool |
Date: | 2025-10-14 04:47:12 |
Message-ID: | e6712f2443214ee4804d3838cc75fe78@sjmresorts.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgpool-general |
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]
From | Date | Subject | |
---|---|---|---|
Next Message | chongin119 | 2025-10-15 01:24:33 | About PG-Pool Load balance configuration |
Previous Message | VASUKI M | 2025-10-10 12:17:09 | Automating Failover Resync & Re-Attach in pgpool2 |