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 1vDeYk-00Cyaa-5Z for pgpool-general@arkaria.postgresql.org; Tue, 28 Oct 2025 07:56:02 +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 1vDeYi-00BSet-LV for pgpool-general@arkaria.postgresql.org; Tue, 28 Oct 2025 07:55:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vDeYi-00BSem-1A for pgpool-general@lists.postgresql.org; Tue, 28 Oct 2025 07:55:59 +0000 Received: from mail-japaneastazlp170110002.outbound.protection.outlook.com ([2a01:111:f403:c405::2] helo=TYVP286CU001.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vDeYe-004AfG-1k for pgpool-general@lists.postgresql.org; Tue, 28 Oct 2025 07:55:57 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=frX+AqlbFIGNMQFf+iCQYZAKFrLiAB/dzXwGe4XCAKpWoLeo92a9V2MetT5084l27mOUSytDGM8pUgksEel5EigQon4jzSn9hdrw14aZ4AcOvj1CMR3/8eWkKSqMWEHjgddGIivac8KONuP8C/so4XaVuyZ2ifoiltWE8ILBCfb/8RWYveWgP8iC7evCFgjywFlUhYtwyGqEZLKKCe6UPk5jMoFS4oTFpEXzXyg27Vbnnfs4+fme1VguP/jP9J4NayVS8NbLk+2t4JeXJ9/F+cRXxvIue9e9EVyjrYVLNVk9aJSX5S7tfBQtLsQlup7uMPTVJeeaeQwreLeDT1ISnA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=gE9MbyZJLj58KVR8vgfUuXhpoK9+K7XSGb7Jhtc8e10=; b=UvuOElRidr1SqRfYEzdqCyxznDFCUaTXDEjOxUCAikMVJfs/Bqnv9nRb3zDgyv8GqbRlRtCxQGZoxvUrVVQV06U4lBlEWsJeRmRzPy5lD6yOXzghf4PPJrK+1Q1OGtRnCMTO4teeuRPvC3s8KrjbiCAzV82yxbMYHguXbhSQ7G7e+7005HdpG3frFQuLexaZalYBLkMsWBPXAS9wS7snJSSu31dlh1UuA4eiZa3sLYqMwa4EV9W/d594s3kDNW76i6faUI2Nte0IwpZiPfxin/cmc8JWBfqR5TwDcp+JawhmliBd+tUd6ZnPZ/NlsBqdPVrxZJi/7meH2248CSc66A== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=sraoss.co.jp; dmarc=pass action=none header.from=sraoss.co.jp; dkim=pass header.d=sraoss.co.jp; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sraoss.co.jp; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=gE9MbyZJLj58KVR8vgfUuXhpoK9+K7XSGb7Jhtc8e10=; b=Nh0fajAxHoBKhQET65XTmQRboEbuCXN/hMKGN/uVHozwm6Ey8qj6DhFTdFFCsZ63XVnoBuKIEode1VLZC7qumyLrKgTBz6hBQZU5NxI5Li3UOESOhAzYIUxI6D91j8yDtR3eqrhfTAmQ/S/uq1wrQItfWvZPLXTJniH60aeL1SFO3yu8pytFFAQchf7aL9AA5naKd1yO6SagszEfs/UQoC5C/scU0JQfel6AQDDG0/Lsv20pg2O7Ra07Nc5ANaE8Az37cY83S8rkUYfV9jpvQ2DzZYnQp7FLCjaX3ztO4SG0UtUh81VmRTwlxQHh8vlaMMxvrfH/V4Ll2pK6+8TJjA== Received: from TYYP286MB2931.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:30d::7) by TYWP286MB2826.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:24a::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9228.12; Tue, 28 Oct 2025 07:55:49 +0000 Received: from TYYP286MB2931.JPNP286.PROD.OUTLOOK.COM ([fe80::fb09:14f2:20b1:1d5e]) by TYYP286MB2931.JPNP286.PROD.OUTLOOK.COM ([fe80::fb09:14f2:20b1:1d5e%5]) with mapi id 15.20.9253.018; Tue, 28 Oct 2025 07:55:49 +0000 From: Koshino Taiki To: "chongin119@icloud.com" CC: "pgpool-general@lists.postgresql.org" Subject: Re: About PG-Pool Load balance configuration Thread-Topic: About PG-Pool Load balance configuration Thread-Index: AQHcPXOQrg54+k0ZdUWxoi6z2c8K1rTXRKHx Date: Tue, 28 Oct 2025 07:55:49 +0000 Message-ID: References: <900F6344-0C8F-4325-AB8F-6DDE7A400924@icloud.com> In-Reply-To: <900F6344-0C8F-4325-AB8F-6DDE7A400924@icloud.com> Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=sraoss.co.jp; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: TYYP286MB2931:EE_|TYWP286MB2826:EE_ x-ms-office365-filtering-correlation-id: 260c53fe-a945-4f07-66d4-08de15f768be x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|366016|38070700021|13003099007|8096899003|7053199007; x-microsoft-antispam-message-info: =?iso-2022-jp?B?WFdaRzhCamdiQzNnVzdtMkNUSFBOL21iVjBvYUdWOVFzYk9jMEdocms1?= =?iso-2022-jp?B?WTRUaXNtMkFJQ1A4aTJXelpPUFZETFQyQmZXRzMrMGxjbkRPR1I1aC9z?= =?iso-2022-jp?B?RTdrS3FGQ0dVRy9FR3JyYm15SlBicTIvKzhuU2xvUGhjSm1GRXREcXFZ?= =?iso-2022-jp?B?aUtGaVpmYlFUdi84eDFVc2tGbFovOFE1WUwxamtSMWVWSUZqZ3lxdm5W?= =?iso-2022-jp?B?N05LUzF4QU9NKzltTGRDMDdmNUI4aWJWNmVjZmwwc2R1di91amZxN0ZW?= =?iso-2022-jp?B?NFF3S0EyeWhmc2JqV3dya2FPamtVSmxPdGRvUVVUakp1WWtFMVU4Nmpv?= =?iso-2022-jp?B?ejYzcFExZVVJcUhrRW1NSVFrQXBxNzZjWUtheEJjdmE1UTMzdTdrTWpS?= =?iso-2022-jp?B?YmFSNFFSaE9wU2UzeUQ1bFpEQlJLMWRxdHRBc3FacGZnNlhXTUZNaU9r?= =?iso-2022-jp?B?M1hPTVFRNVpZOC9NbjYxd2RydE8wcERDc3YxdCtYeVZ0OEJzZUNzbkpp?= =?iso-2022-jp?B?UENmV2FraERNQVZCQklINVZ3QTNPWncvSHpxMmQxNS9UWGVFRTBwOUJU?= =?iso-2022-jp?B?Z3VqNWRBM3VIQllWUnF3azc1N0lFbXZ4MW1JUGhxek0yVzdReWh4aGtH?= =?iso-2022-jp?B?VGk5ZTc3TWNnNll3Q05DNDBLT0VlQWdYVGx2K2ZBZGhDUDY3VmFjOUQ3?= =?iso-2022-jp?B?cVA0NTBBRE1Fc09Ybk91eTcrS2J2UEIvVTNqVWRFbXB3RU1OdjdmTzgw?= =?iso-2022-jp?B?aW9ZaXM5MTkxeStUdkJybGZjbE90aUN6VzhmaWZXODVYU0duTWtzL3NZ?= =?iso-2022-jp?B?Tzh0QzQ3VW85c1NHb0FKeWI1TUd4SFhrbGNwOFN4S1NwclVPOGlrc1ZL?= =?iso-2022-jp?B?WmhVTm5QRGcweEk4c2VNZVJHbWZQVkw5OGpMdU1ZaU5HZjAxdjlpeS9Y?= =?iso-2022-jp?B?QXdlYkdBU29JT2tFSHkzSDduVmZyY08rajFqUXpKV0tsano2dUw4Yytr?= =?iso-2022-jp?B?b2o2Y3hjcVpyVFJZeWVreS9teGphR015ZGNFZWR1Z2hzZTFsOWRPM0Nl?= =?iso-2022-jp?B?Wlk4Wld6aVpOYmpVMDZYRE8wYk53ZWNUVmZzbVJmSGxmb1M4Sko0MUFM?= =?iso-2022-jp?B?Y3J1S04vcjh3eXNEZjJrTEtEM2M5QTVJNGZYME1pYzZCb25jRFNRWDJ4?= =?iso-2022-jp?B?YnBjbXJ5Q3BEYTNOSkJSRTV4c3NxWjVpNnBBOGVKZjdNY1VoWk9yTmJ6?= =?iso-2022-jp?B?NGgzM09tZXNtUklabzU5c0FZWWEzTjc1RjhaOFdiYkc3Q3AybGpZcmJI?= =?iso-2022-jp?B?Z1lBZklwdXRqM0RRUkRqZjg5T0ZxYkNLelkwQWw4OU03TnhHbW92dURw?= =?iso-2022-jp?B?ZHZaYlcvRnovaXJYdzh2bEsrazEvQzVtWkJzSlIrSTBEdERaS21HTS96?= =?iso-2022-jp?B?WHJVKzZub1c3WmViODhWaDhUbmxYL292SzdNbDVpTWtlRVZKd2NndEMy?= =?iso-2022-jp?B?NGNJa1N3eTVYWWtXRjBteEpkbVVTcDV2N1diam5HYVBtM3VrRUJ3bDhl?= =?iso-2022-jp?B?eE1vR0pYWWk4SitZQ0k1ZVRIUjNlSGptTmExUjdrMUE4cHBzVGVSUy82?= =?iso-2022-jp?B?UUd4N1U2VnVzeXE3eEdtbDFkQ1h1aU9vQ3ZsMXNIaHBXRXRSRVVvVlg4?= =?iso-2022-jp?B?YlhwS2I3V2Y3dEVScFBCNnB0S3luNlVmdk04SXI4RmwxSDVJNjJxMEVi?= =?iso-2022-jp?B?N3JUNDQ5d0N2L1JLbDVkejNZaVlRR0g4RzBFMjNRWW9idzFubFhLOWVB?= =?iso-2022-jp?B?T2ZscytCOEpXWkI4N2ltNEN1dXNRN1VaZUtFVUJKS3F2dWw4NGV3Vjla?= =?iso-2022-jp?B?bXRPUkR1Y1g5eHZnQlNjVldmSkdyL0ZUdTc0R0dHTlRFMERpR3R3M3Jj?= =?iso-2022-jp?B?dXJXak5XcGRwSnBjbnpzcGg0NFRJU2VWeTRBd3d6NE9xWm9aalN5dTdh?= =?iso-2022-jp?B?VDZWU3pteUlKVDhPeXVsbDhqS29pUHVoMmxZWTNsWUU1VU9HeTFSRncv?= =?iso-2022-jp?B?QkNrZUtVdjVPWlZDNTRpVWh1UGhDSjJkOStFTVpLOGd5YUlwL2Z0WElJ?= =?iso-2022-jp?B?NTE=?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYYP286MB2931.JPNP286.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(366016)(38070700021)(13003099007)(8096899003)(7053199007);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-2022-jp?B?T3QrWDJtZlcvZ3hBZGRrNEVyenJWRUJzbFFxci9ObHVPUlJRenZzY3hL?= =?iso-2022-jp?B?aysydmJTNTdMUW9Zc05lR3o1c2dkNGFuMndlSkwzNVVwT1FoVWllT3NO?= =?iso-2022-jp?B?dXdtMUpPZWVqNGNYTENRS0dBZ04zZlVXbGJDa0lvc0plUVI1M1creUJh?= =?iso-2022-jp?B?ZGg2Unc3TzhqNHNPTG1GczdJM1FyQXFqSUFrWmtPaGZ2WUJlUmZTbkFS?= =?iso-2022-jp?B?dGpsSHRCUEQvYWpLWmUvZCtzNG5JUEhPRzNmYWF4UE5Gdkl4eWxGM2pl?= =?iso-2022-jp?B?REVwYUdsSmVVR21xNTNBenIycHFERFhMS2kzU1ROVXY3UDN4SU8vNS9F?= =?iso-2022-jp?B?amoxbndFOXpvWERWR3A3WmR4blZGWTlDejdEZnlmSmpjKzlLSEorSndZ?= =?iso-2022-jp?B?TmJXWWFyRmFmQkx2TWhwN3AyYkNEN2REdUs3N3RrdDlhdmRZU1g2WFhi?= =?iso-2022-jp?B?NWFCaGh2Y1ViVXpkM3lvN1dYdjIxRUJmVkdEbG5xOC9OT2U3NWhPdm9U?= =?iso-2022-jp?B?R1RLcUxVUzhJQjQwZW9oY0VDNHF3bDltS1JqbmViZzRic1lSS1lDdlhp?= =?iso-2022-jp?B?TGI4OHg3aXI2T1l2U0xIakNTam9FWXJRSlVFbTNJN1UzNk1lMU5OK3c2?= =?iso-2022-jp?B?UE1lNkp4UFZXNkhYRXkzVHFnbThpRE9CZDVGZEt6QmF2aFFYdjcwMUxq?= =?iso-2022-jp?B?VmE3WTVyVVcvaVZKQjVRSTA1em5JSDZzRGIvNGpjYjMyVDdJQVRmZGVl?= =?iso-2022-jp?B?MUp4bEN0SjRYNVE5cDFUOGQxeDV6Tno3N3ZsczQwM1V1OHNVS1YrNndY?= =?iso-2022-jp?B?bGNDQjMwcTRNQktpU0g0b296MlM3WTR0WVdaaWpTQWNSTTZiL1d1d2Zz?= =?iso-2022-jp?B?M3lvZzhtd21PbkJzVkZsdzlVZjhUaWtzRmR0VnMwaU5GZ0hGSWVVejhT?= =?iso-2022-jp?B?VnozWDNha3dBWmV6SEdHbzJ1bmFkY0ZGcWRGZXJMSHZRNTRvdEtTZHB2?= =?iso-2022-jp?B?RU9sUlNySUtWdG1HWVpmR0piL2lVQkdLTXV5cnJZa1k1MGF3KzUvckM4?= =?iso-2022-jp?B?dFdSYVUyWGdDc0JQUzd2aW1SS29aV0l6K2Vid3MrUmt0QlRUbkowREo5?= =?iso-2022-jp?B?dm56QW5mV1kvS05hYllOQ0txcHdrVWZCNUFDZzFNLzRSaHZkVTZDbGQ2?= =?iso-2022-jp?B?ZndjaUp2TmNXams5THB2OGRQWHdFZlpvUHYyL2lqajhCQURDdkNQMWRN?= =?iso-2022-jp?B?VktySkU1US8zZXRwNkc4SnJmTW5kME80bzUrM1VQQ0o1U0l1VTRNaTA4?= =?iso-2022-jp?B?Mmc5VWxNK3dNZnVJVDJHQ3hqbTFzRmNKZUNYRWFzMFpCNTFGbzc1S2JD?= =?iso-2022-jp?B?TVFMZWcraGtpR2luSis5WDZKeXBjdnkrWCtVRDNjbFBDakVhQ0ZhWGFy?= =?iso-2022-jp?B?Ym5tYkFVSjBiK3JMWmsrSlJyc3JiM1JSRmxKaVgybGNQRHpRVGMvdkNS?= =?iso-2022-jp?B?OURLUDc3TXdHRnYweWY1bmFvcDBwUHpoUnpHQTZmMitlNGZFdHhoMXRz?= =?iso-2022-jp?B?WHVCbWxTQXhuOTIxcWdPNFJqRkRFQUp2Ykp4aFpRYWFOaklvcHBQZkJE?= =?iso-2022-jp?B?QUhWa1VKTlRKWFF3dDdWWnN4b0RPc2lpYnNFTy9CYTlKWU9mMUNRMGM2?= =?iso-2022-jp?B?YnRvejNEL0pUbkg4cncwQW9Hc2h6dlMyOXViWGxsWURJQXdqM2ppQS9U?= =?iso-2022-jp?B?SllhNUpWZHYxTHUzV0hJa1lyNkRtREtSZjNEQXRiQ0FDRHJjQXVyczJt?= =?iso-2022-jp?B?R0tDLzRtTTBlWDB1eHV2enFUUzhjYVIrbEkzTFd2dHNNaEtvMGtwZzh5?= =?iso-2022-jp?B?eWNoVnp5OUJqMHhQcVVQT2xjazkvQzA4YVpvSG5nWVdYSWsrNlZvMHhx?= =?iso-2022-jp?B?NDc4OGlTMlVHZ25ZazN4dENOcGhvempHdHliZW1uWlBReTNHbUhTYjBi?= =?iso-2022-jp?B?NjFQTlVhZEpFVjd3VzRmZkF1NHJUNkZhUko5MUJrUW81YlRUc1ViN1pT?= =?iso-2022-jp?B?WG5uRjB1WmNxNHUvR0h4ZllEMDZncmFEa0VzZ1pvQjR0QnMrNVFpOU5x?= =?iso-2022-jp?B?UDhBMnJIT2U3MURIL1I2bTVGY2FwMlllUFIxZUJCRHRYWEtTTEVUd2c1?= =?iso-2022-jp?B?eVAwbGpOSFRUa3BPajFVTDB1YlZzSFpDLy81Z3RzOUh2TTcrcGRrK2VJ?= =?iso-2022-jp?B?K0NCNGY0enFkUHNlbnlpS0FpbTliczBQbGZkWFNqN1V5bjFFcEZGZzdK?= =?iso-2022-jp?B?NE9qMA==?= Content-Type: multipart/alternative; boundary="_000_TYYP286MB29312718F3957A43EC83677E94FDATYYP286MB2931JPNP_" MIME-Version: 1.0 X-OriginatorOrg: sraoss.co.jp X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYYP286MB2931.JPNP286.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 260c53fe-a945-4f07-66d4-08de15f768be X-MS-Exchange-CrossTenant-originalarrivaltime: 28 Oct 2025 07:55:49.1491 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 75db6c32-352e-4063-ae79-cafb8623f6db X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: jEKrY8xysCntYyTmhuJGep6I0GpGIoQnFhrOYk6a//QNaHktiuHrfNQ4xHz1LDSKIsQ0WBXob/R3tUAeSrRi7Q== X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYWP286MB2826 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_TYYP286MB29312718F3957A43EC83677E94FDATYYP286MB2931JPNP_ Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable You can exclude specific SQL statements from load balancing by using either= the allow_sql_comment or primary_routing_query_pattern_list settings, in a= similar way to the /*NO LOAD BALANCE*/ comment. When allow_sql_comment is set to off, you can disable load balancing for a = particular SQL statement by adding any comment at the beginning of the quer= y. For example: /* any comment */ SELECT 1; Also, you can specify SQL patterns that should not be load-balanced by usin= g the primary_routing_query_pattern_list parameter. For example: primary_routing_query_pattern_list =3D 'SELECT 1\;' For more details on how to configure these options, please refer to the off= icial documentation: https://www.pgpool.net/docs/45/ja/html/runtime-config-= load-balancing.html Taiki Koshino SRA OSS K.K. TEL: 03-5979-2701 FAX: 03-5979-2702 URL: https://www.sraoss.co.jp/ ________________________________ =1B$B:9=3DP?M=1B(B: chongin119@icloud.com =1B$BAw?.=1B(B: 2025 =1B$BG/=1B(B 10 =1B$B7n=1B(B 15 =1B$BF|=1B(B (=1B$B?eM= KF|=1B(B) 10:24 =1B$B08@h=1B(B: pgpool-general@lists.postgresql.org =1B$B7oL>=1B(B: About PG-Pool Load balance configuration Dear pgpool-general, I have already set up a cluster(base streaming replication) with three pgpo= ol 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 =1B$B!H=1B(Bstatement_level_load_b= alance=1B$B!I=1B(B to on and =1B$B!H=1B(Ballow_sql_comments=1B$B!I=1B(B 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 =1B$B!H=1B(B/*= NO LOAD BALANCE*/=1B$B!I=1B(B 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 --_000_TYYP286MB29312718F3957A43EC83677E94FDATYYP286MB2931JPNP_ Content-Type: text/html; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable
You can exclude specific SQL statements from load balancing by us= ing either the allow_sql_comment or primary_routing_query_pattern_list sett= ings, in a similar way to the /*NO LOAD BALANCE*/ comment.

When allow_sql_comment is set to off, you can disable load balanc= ing for a particular SQL statement by adding any comment at the beginning o= f the query.
For example:
/* any comment */ SELECT 1;

Also, you can specify SQL patterns that should not be load-balanced by= using the primary_routing_query_pattern_list parameter.
For example:
primary_routing_query_pattern_list =3D 'SELECT 1\;'

For more details on how to configure t= hese options, please refer to the official documentation: https://www.pgpool.net/docs/45/ja/html/ru= ntime-config-load-balancing.html


Taiki Koshino<koshino@sraoss.co.= jp>
SRA OSS K.K.
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www= .sraoss.co.jp/



=1B$B:9=3DP?M=1B(B: chongin119@icloud.com <chongin119@icloud= .com>
=1B$BAw?.=1B(B: 2025 =1B$BG/=1B(B 10 =1B$B7n=1B(B 15 =1B$BF|=1B= (B (=1B$B?eMKF|=1B(B) 10:24
=1B$B08@h=1B(B: pgpool-general@lists.postgresql.org <pgpool-= general@lists.postgresql.org>
=1B$B7oL>=1B(B: About PG-Pool Load balance configuration

Dear pgpool-general,

 

I have already set up a cluster(base streaming replication) with three pgpo= ol 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 =1B$B!H=1B(Bstatement_level_load_b= alance=1B$B!I=1B(B to on and =1B$B!H=1B(Ballow_sql_comments=1B$B!I=1B(B 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 =1B$B!H=1B(B/*= NO LOAD BALANCE*/=1B$B!I=1B(B 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-balancin= g.html (have /*NO LOAD BALANCE*/)

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

 

Do you have any idea about this?


Best Regards,

Terence

--_000_TYYP286MB29312718F3957A43EC83677E94FDATYYP286MB2931JPNP_--