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 1uoxTo-00DhAM-Kq for pgpool-hackers@arkaria.postgresql.org; Thu, 21 Aug 2025 05:04:54 +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 1uoxTo-00Dvoj-3q for pgpool-hackers@arkaria.postgresql.org; Thu, 21 Aug 2025 05:04:52 +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 1uoxTn-00Dvoc-UR for pgpool-hackers@lists.postgresql.org; Thu, 21 Aug 2025 05:04:52 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uoxTl-000xgq-2L for pgpool-hackers@lists.postgresql.org; Thu, 21 Aug 2025 05:04:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type: Mime-Version:References:In-Reply-To:From:Subject:Cc:To:Message-Id:Date:Sender :Reply-To:Content-ID:Content-Description; bh=wUW80DNnDO+gndFra8YNrx0MknelEBDZjwzcpd1cQLc=; b=IJX4EqNnC7mkvX1qRc+aE+mZrR 8AUwbcJupU1KTxAk4Pf2CDZpa3qbEwrne13Wzvnui8ax3ZbKo+G6Rni6jO1sl4oie8Wuhmf1GctAX cots9t6qtuv91W5YK+LeDg+um2rafNijcncfB8Lf4F3kem5a1y+J/J+PlUsNGxMV2O0AAq9syibUH xlYsOllDf5+sVKMgrffvhj8KtBk6Vb1NI1OioEjMYAI28ObxieRszL8jEMi4t487rRVSHV9HyuD/t 4s01oYqptDTn7NPsf/uX10+59G9RDICbEca771uYS6l5ianHx3kYoI/MXRV7x/jJ2uJIFOKeDTec+ fBqIT6LQ==; Received: from [2409:11:4120:300:5fcb:9797:4f33:e62e] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256 (Exim 4.96) (envelope-from ) id 1uoxTi-002Kxx-1B; Thu, 21 Aug 2025 05:04:49 +0000 Date: Thu, 21 Aug 2025 14:04:34 +0900 (JST) Message-Id: <20250821.140434.533994102324088664.ishii@postgresql.org> To: nadav@tailorbrands.com Cc: pgpool-hackers@lists.postgresql.org Subject: Re: Proposal: recent access based routing for primary-replica setups From: Tatsuo Ishii In-Reply-To: References: <20250820.214537.1156323467943836247.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 26.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=utf-8 Content-Transfer-Encoding: base64 X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:5fcb:9797:4f33:e62e (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgTmFkYXYsDQoNCj4gSGkgVGF0c3VvLA0KPiANCj4gVGhhbmsgeW91IGZvciB5b3VyIHJlcGx5 LCBJIGFncmVlIHdpdGggeW91ciBhcHByb2FjaC4gQmV0dGVyIHRvIGdldCAoMSkgb3V0DQo+IG9m IHRoZSB3YXkgZmlyc3QuDQo+IA0KPiBBcyBhIHNpbXBsZXN0IGFwcHJvYWNoIHRoYXQgd2UgY2Fu IGltcGxlbWVudCB0aGF0IHdvdWxkIHN1cHBvcnQgY29tcGxldGVseQ0KPiBvZmZsb2FkaW5nIHRo ZSByZXNwb25zaWJpbGl0eSBvZiB0aGUgbGFnIGNoZWNraW5nIHdlIGNhbiBzZXQgaXQgdG8g4oCc ZmlsZeKAnQ0KPiBhbmQgYWRkIGFub3RoZXIgY29uZmlnIGZvciBmaWxlIHBhdGguIE9yIGp1c3Qg aWYgc3RhcnRzIHdpdGgg4oCcZmlsZTrigJ0gaXTigJlsbA0KPiB1bmRlcnN0YW5kLg0KDQpNeSBj b25jZXJuIGFib3V0IHRoZSAiZmlsZToiIGFwcHJvYWNoIGlzLCByYWNlIGNvbmRpdGlvbi4gV2hh dCBpZg0KcGdwb29sIHJlYWRzIHRoZSBmaWxlIHdoaWxlIGl0IGlzIGJlaW5nIHVwZGF0ZWQgYnkg c29tZW9uZSBlbHNlPyAgQWxzbw0KSSB0aGluayB0aGUgY29tbWFuZCBhcHByb2FjaCBpcyBtb3Jl IGZsZXhpYmxlIGFuZCBnZW5lcmljLiBGb3INCmV4YW1wbGUsIHRoZSAiZmlsZSBhcHByb2NoIiBj YW4gYmUgZWFzaWx5IHNpbXVsYXRlZCBieSBzZXR0aW5nIHRoZQ0KY29tbWFuZCAiL3Vzci9iaW4v Y2F0IHBhdGhfdG9fdGhlX2ZpbGUiLg0KDQo+IFRoZW4gdGhlIGludGVybmFsIHBvbGxpbmcgY2Fu IGp1c3QgcmVhZCB0aGUgZmlsZSBvbiBzY2hlZHVsZS4gVGhlIGVudGlyZQ0KPiB1cGRhdGluZyBt ZWNoYW5pc20gd2lsbCBiZSBsZWZ0IHRvIHRoZSBleHRlcm5hbCBzZXJ2aWNlLg0KDQpJbnRlcm5h bCBwb2xsaW5nIGlzIGEgbGl0dGxlIGJpdCBjb21wbGljYXRlZCBhbmQgd2lsbCBub3QgYmUgZWFz aWx5DQpjaGFuZ2VkIHRvIGp1c3QgcmVhZGluZyBhIGZpbGUuIFRoZSBpbnRlcm5hbCBwb2xsaW5n IGhhcyB0d28gb3B0aW9uczoNCm9uZSBpcyBjaGVja2luZyBXQUwgTFNOIGRpZmZlcmVuY2UsIHRo ZSBvdGhlciBpcyByZXBsaWNhdGlvbiBkZWxheSBpbg0KdGltZS4gVGhlIGZpbGUgYXBwcm9jaCB3 b3VsZCBvbmx5IHJlcGxhY2UgdGhlIGxhdHRlci4gSSBzdWdnZXN0IHRvDQpsZWF2ZSB0aGUgaW50 ZXJuYWwgcG9sbGluZyBjb2RlIGFzIGl0IGlzLg0KDQo+IEhhdmluZyB0aGlzIGFzIGEgZmlyc3Qg c3RlcCBhbHNvIG9wZW5zIHVwIHRoZSBkb29yIGZvciBvdGhlcg0KPiBpbXBsZW1lbnRhdGlvbnMu DQo+IA0KPiBBbm90aGVyIGNsYXNzaWMgb3B0aW9uIHdvdWxkIGJlIGNhbGxpbmcgYW4gQVBJIGVu ZHBvaW50LiBCdXQgdGhhdCBtaWdodA0KPiBjb21lIHdpdGggYSBsb3QgbW9yZSBidWxrIGFuZCBz ZWN1cml0eSBjb25jZXJucy4NCg0KSSBhZ3JlZSB0aGF0IGNhbGxpbmcgQVBJIGNvdWxkIGJyaW5n IHNlY3VyaXR5IGNvbmNlcm5zLg0KDQpCVFcsIGluIHRoZSBjb21tYW5kIGFwcHJvY2gsIHRoZSBj b21tYW5kIHNob3VsZCBiZSBleGVjdXRlZCBhcw0Kc3JfY2hlY2tfdXNlci4NCg0KPiBJIHN1Z2dl c3QgSSB3b3JrIG9uIGEgcGF0Y2ggZm9yIGZpbGUgc3VwcG9ydC4NCj4gDQo+IFdoYXQgZG8geW91 IHRoaW5rPw0KDQpGb3IgdGhlIHJlYXNvbiBhYm92ZSBJIHByZWZlciB0aGUgY29tbWFuZCBhcHBy b2NoLCBub3QgdGhlIGZpbGUNCnN1cHBvcnQuDQoNCj4gTmFkYXYgU2hhdHoNCj4gVGFpbG9yIEJy YW5kcyB8IENUTw0KPiANCj4gDQo+IE9uIFdlZCwgQXVnIDIwLCAyMDI1IGF0IDM6NDXigK9QTSBU YXRzdW8gSXNoaWkgPGlzaGlpQHBvc3RncmVzcWwub3JnPiB3cm90ZToNCj4gDQo+PiBIaSBOYWRh diwNCj4+DQo+PiBUaGFuayB5b3UgZm9yIHRoZSBhbnN3ZXIuDQo+Pg0KPj4gSSB0aGluayB5b3Vy IHByb3Bvc2FsIGFjdHVhbGx5IGluY2x1ZGVzIHR3byBvcnRob2dvbmFsIHByb3Bvc2Fscy4NCj4+ DQo+PiAoMSkgImluamVjdCIgcmVwbGljYXRpb24gZGVsYXkgdmFsdWUgZnJvbSBleHRlcm5hbCBz b3VyY2UgKGluIHlvdXINCj4+IGNhc2UgZnJvbSBBdXJvcmEpLg0KPj4NCj4+ICgyKSBwZXIgcmVs YXRpb24gcmVjZW50IGFjY2VzcyBiYXNlZCByb3V0aW5nLg0KPj4NCj4+IEkgc3VnZ2VzdCB0byBp bXBsZW1lbnQgKDEpIGZpcnN0LCB0aGVuICgyKS4gVGhpcyBpbmNyZW1lbnRhbCBhcHByb2FjaA0K Pj4gd291bGQgYmUgZWFzaWVyIHRoYW4gaW1wbGVtZW50aW5nICgxKSsoMikgYXQgb25jZS4NCj4+ DQo+PiBGb3IgKDEpIHdlIGNvdWxkIGFkZCBuZXcgcGdwb29sLmNvbmYgcGFyYW1ldGVyLCBzYXkN Cj4+ICJyZXBsaWNhdGlvbl9kZWxheV9zb3VyY2UiLiBJZiBpdCBpcyBzZXQgdG8gImJ1aWx0aW4i LCB0aGVuDQo+PiByZXBsaWNhdGlvbiBkZWxheSBzb3VyY2UgaXMgUG9zdGdyZVNRTCBhcyB3ZSBh bHJlYWR5IGRvZXMgdG9kYXkuIElmDQo+PiBpdCdzIHNldCBvdGhlciB0aGFuICJidWlsdGluIiwg dGhlbiBpdCdzIGFuIGV4dGVybmFsIGNvbW1hbmQgbmFtZSAoKw0KPj4gYXJndW1lbnRzKSB0byBi ZSBleGVjdXRlZCB0byBpbXBvcnQgcmVwbGljYXRpb24gZGVsYXkgdmFsdWUuIFRoZQ0KPj4gY29t bWFuZCBzaG91bGQgcmV0dXJuIHJlcGxpY2F0aW9uIGRlbGF5IHZhbHVlIHJlcHJlc2VudGVkIGlu IHN0cmluZ3MNCj4+IGxpa2UgIjAgMjAgMTAiLCB3aGljaCBtZWFucyBub2RlIDAsIDEgYW5kIDIg cmVwbGljYXRpb24gZGVsYXkgdmFsdWVzDQo+PiBpbiBtaWxsaXNlY29uZCAoaW4gdGhpcyBjYXNl IHNpbmNlIHRoZSBub2RlIDAgaXMgcHJpbWFyeSwgaXRzDQo+PiByZXBsaWNhdGlvbiBkZWxheSBp cyAwKS4gVGhlIGNvbW1hbmQgd2lsbCBiZSBpbnZva2VkIGV2ZXJ5DQo+PiBzcl9jaGVja19wZXJp b2QuDQo+Pg0KPj4gSSBhbSBub3Qgc3VyZSBpZiB0aGlzIGFjdHVhbGx5IHdvcmtzIGluIEF1cm9y YS4gVGhpcyBpcyBqdXN0IGEgcXVpY2sNCj4+IGlkZWEuDQo+Pg0KPj4gKDIpIHdvdWxkIGJlIHBy b2JhYmx5IG11Y2ggaGFyZGVyIHRoYW4gKDEpLiBTbyB3ZSBuZWVkIG1vcmUgZGlzY3Vzc2lvbg0K Pj4gbGF0ZXIgb24uDQo+Pg0KPj4gQmVzdCByZWdhcmRzLA0KPj4gLS0NCj4+IFRhdHN1byBJc2hp aQ0KPj4gU1JBIE9TUyBLLksuDQo+PiBFbmdsaXNoOiBodHRwOi8vd3d3LnNyYW9zcy5jby5qcC9p bmRleF9lbi8NCj4+IEphcGFuZXNlOmh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwDQo+Pg0K