Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v8qNJ-005MWI-2Q for pgpool-general@arkaria.postgresql.org; Wed, 15 Oct 2025 01:32:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v8qNH-0041cK-3d for pgpool-general@arkaria.postgresql.org; Wed, 15 Oct 2025 01:32:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v8qG4-003zQ6-Hu for pgpool-general@lists.postgresql.org; Wed, 15 Oct 2025 01:24:51 +0000 Received: from p-west1-cluster6-host11-snip4-4.eps.apple.com ([57.103.67.7] helo=outbound.pv.icloud.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v8qG0-002EBo-2o for pgpool-general@lists.postgresql.org; Wed, 15 Oct 2025 01:24:51 +0000 Received: from outbound.pv.icloud.com (unknown [127.0.0.2]) by p00-icloudmta-asmtp-us-west-1a-20-percent-2 (Postfix) with ESMTPS id 6ED281800424 for ; Wed, 15 Oct 2025 01:24:45 +0000 (UTC) Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=icloud.com; s=1a1hai; bh=3PCI4vtyWsBQuJYKhdmMLo7xAj7DZSkkvVT91tAxGRg=; h=From:Content-Type:Mime-Version:Subject:Message-Id:Date:To:x-icloud-hme; b=A+dNCp93Cg6LZ7aJnWjyBe2T5ZS2/DCr6sM+3aaXKlKRTAXnIXyFv93WhxB+gzZrJIeMCdxw43spXpi6yImP/FuqtQYywE4fXe1H7W6q9ppTN6j7kCFUo+MzSDwrD1V/bly5M5mQvqQU8hAt+MxYCQqjB8Nc2g+7VTX8+j82LP/o8M493h+Tpow3Uu1xWvnlYnERQJqiUT7McKovrYanDEuYYcVcm2HG1Hzfxwac5btoa9BEw4YkMSn0bMMLJjV9iH2Ngb7Zk/olRw1DBqtz8PMviWOFl7Z3Fh0cNSpDv7nalB9z1R3HtddiAvQEw/BtJ3oouJ9fJvC4c2RxwN5kwQ== Received: from smtpclient.apple (unknown [17.56.9.36]) by p00-icloudmta-asmtp-us-west-1a-20-percent-2 (Postfix) with ESMTPSA id ACC7718000A3 for ; Wed, 15 Oct 2025 01:24:44 +0000 (UTC) From: chongin119@icloud.com Content-Type: multipart/alternative; boundary="Apple-Mail=_688BE3E0-A385-45C7-8C05-59DC86D4A991" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.100.1.1.5\)) Subject: About PG-Pool Load balance configuration Message-Id: <900F6344-0C8F-4325-AB8F-6DDE7A400924@icloud.com> Date: Wed, 15 Oct 2025 09:24:33 +0800 To: pgpool-general@lists.postgresql.org X-Mailer: Apple Mail (2.3864.100.1.1.5) X-Proofpoint-ORIG-GUID: Bi6mlj8MurYOSl0KXO2C3lBsTaM1v3nm X-Proofpoint-Spam-Details-Enc: AW1haW4tMjUxMDE1MDAwNyBTYWx0ZWRfX3xx4GXg/AlqO MNin28ySKFehG6wWjp+j+GzJBIufgdS6SL8o57NSrMXWhTP1/HuiZEYWu99FlqoVW4gDuWMhQZK oBMsZI8Qrjefb2zTzVifdNtE0n8+nqakKlKsWBHazzU5lcnYxdTpIfq98k0CkJ7rNImhxC8zd61 kZCU85ivx4lRbUbrckbk6epwuFlHv6A/04HmNTmaZ3390eR/1mYtyLOfkTLICYj+Te6rHKOsFzS 6WRGeijjmQ6knIVdCZ+yxQpCTIgdnxSApVxysRCqYYMHo93uBfHHJuSdZShOV8qbcg3ABOVbA= X-Proofpoint-GUID: Bi6mlj8MurYOSl0KXO2C3lBsTaM1v3nm X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1121,Hydra:6.1.9,FMLib:17.12.80.40 definitions=2025-10-15_01,2025-10-13_01,2025-03-28_01 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 mlxscore=0 mlxlogscore=995 phishscore=0 spamscore=0 bulkscore=0 clxscore=1031 suspectscore=0 malwarescore=0 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.22.0-2506270000 definitions=main-2510150007 X-JNJ: AAAAAAABx7+oXNKSEj3sK9a9kKjiR9wdPXMaSgB7kuRHC0VkYkxbMzlzDNrAlTVkcQ1Vk2HYiR/mqFrTOJLogYrr77RtqsKWx+t0yXa+A+F0McJtLbtxqRAWVvpSdC96p4KlHiDeCU9X9pcvEkwv+kQjDwgeVjc0a9dk8Yd5P5WqQ09gK3Q+fucYon97xZsG66ON0LxRKPi/dOrge6LjAlpy3C6NcSzP+Jn9S3a8ojcl6A3eb+orSBkjn9xrwW3XT1EnzZKhEIX8RRos75yeLCnI3Tt+CFtfAZU9pocD3YvmcG5YEvbrBjY4Ez0pDdR0fAghBGx46AIGi9XqsI7Gu/UwYoFDX7IfmlSsh4sw2UOHNVsN2cK09e3B3FeUHwd1wO4i3st/GnvkVGbeDSq2jm5+uUC43j/A+ApByIgpwsekFxgEwkaur4ISe3eXQO6JMDW8QXkIi56TIWyNHC9bD0AGm3O6TTdyrxMYlgxxg23g2Z2JsbRRajBwZz5BZyS7Jfr54cPDQk57kse1zBjc4zDmYgFGukagN2yL2Szq0cBBF+z1cJqrxkad5m9PVa9ZiDULtWR2PRjX4aLZ9Q== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_688BE3E0-A385-45C7-8C05-59DC86D4A991 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Dear pgpool-general, =20 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. =20 In our config file of pgpool, I also set = =E2=80=9Cstatement_level_load_balance=E2=80=9D to on and = =E2=80=9Callow_sql_comments=E2=80=9D to off. Now, I have some queries that I want to control whether I use load = balance mode or not. =20 After I checked the documentation, I find out that I can add =E2=80=9C/*NO= LOAD BALANCE*/=E2=80=9D before select query only in pgpool 4.2. But can not add this comment before select query in pgpool 4.5. =20 = 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*/)) =20 Do you have any idea about this? Best Regards, Terence= --Apple-Mail=_688BE3E0-A385-45C7-8C05-59DC86D4A991 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

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 = =E2=80=9Cstatement_level_load_balance=E2=80=9D to on and = =E2=80=9Callow_sql_comments=E2=80=9D 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 =E2=80=9C/*NO LOAD BALANCE*/=E2=80=9D 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-balanc= ing.html (have /*NO LOAD = BALANCE*/)

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

 

Do you have any idea about this?


Best = Regards,

Terence

= --Apple-Mail=_688BE3E0-A385-45C7-8C05-59DC86D4A991--