About load balance mode in pgpool

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]

Browse pgpool-general by date

  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