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 1uqihR-00Btxw-8j for pgpool-hackers@arkaria.postgresql.org; Tue, 26 Aug 2025 01:42:14 +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 1uqihQ-00H0I1-B4 for pgpool-hackers@arkaria.postgresql.org; Tue, 26 Aug 2025 01:42:12 +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 1uqihQ-00H0Ht-5D for pgpool-hackers@lists.postgresql.org; Tue, 26 Aug 2025 01:42:12 +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 1uqihM-001l6y-0m for pgpool-hackers@lists.postgresql.org; Tue, 26 Aug 2025 01:42:11 +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=TZwTd3jVSvskcYyOgx7G4xtvxye7X2LeoAoyKVYPpgM=; b=gCVY52ga2NuJV55+YuliXI6YJL RWXPq3hpktx/jXHOzG3Ur6UP/FD79Swf22wNBSx64ndWfEXw+Tdvwa7Mn7gFvHtJu82QehpWuwjFQ 1quprSXTBm9+mGt6EhHuSvq8pP+iaY9+JrZ8LyLYxqdOcUkQvFWnbXlYdWX8cHZ2Dv/7SVos0X7bO MQoLGvogNyFLlot2kn41D6ayfPr9C5ei9V8aywnXLjFH++L7S0PxU2fYQ45HEcx70r5AlnfVctmGb JQPRAeIVsJGjJl5c2IHFs62rXARbIfk3dwVLXm7dIZJayOZcKak34W4R+i4d30Vin1c9Gl5pY9e+n Hl12ZDDA==; Received: from [2409:11:4120:300:5e99:eb26:581f:d44f] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256 (Exim 4.96) (envelope-from ) id 1uqihI-0048cj-1P; Tue, 26 Aug 2025 01:42:07 +0000 Date: Tue, 26 Aug 2025 10:41:55 +0900 (JST) Message-Id: <20250826.104155.1065705000208094250.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: <20250825.111825.1765418484481637087.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:5e99:eb26:581f:d44f (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgTmFkYXYsDQoNClRoYW5rIHlvdSBmb3IgdXBkYXRpbmcgdGhlIHBhdGNoLiBJIHdpbGwgbG9v ayBpbnRvIHRoYXQuDQoNCkkgaGF2ZSBhIHF1ZXN0aW9uLiBIYXZlIHlvdSBhY3R1YWxseSB0cmll ZCB0aGUgcGF0Y2ggd2l0aCBBV1MgQXVyb3JhPw0KSSBhbSB3b25kZXJpbmcgaG93IHBhdGNoZWQg cGdwb29sIHdvcmtzIHdpdGggQXVyb3JhLiBJIGFtIGFza2luZw0KYmVjYXVzZSBpbiB0aGUgZG9j ICI4LjUuIEF1cm9yYSBDb25maWd1cmF0aW9uIEV4YW1wbGUiOg0KDQogU2V0IHNyX2NoZWNrX3Bl cmlvZCB0byAwIHRvIGRpc2FibGUgc3RyZWFtaW5nIHJlcGxpY2F0aW9uIGRlbGF5DQogY2hlY2tp bmcuIFRoaXMgaXMgYmVjYXVzZSBBdXJvcmEgZG9lcyBub3QgcHJvdmlkZSBuZWNlc3NhcnkgZnVu Y3Rpb25zDQogdG8gY2hlY2sgdGhlIHJlcGxpY2F0aW9uIGRlbGF5Lg0KDQogc3JfY2hlY2tfcGVy aW9kID0gMA0KDQpTbyBzdHJlYW1pbmcgcmVwbGljYXRpb24gY2hlY2tpbmcgaXMgZGlzYWJsZWQs IGFuZCBpdCBtZWFucyB0aGF0IHlvdXINCnBhdGNoIGlzIGFsc28gZWZmZWN0aXZlbHkgZGlzYWJs ZWQgdG9vLg0KDQpCZXN0IHJlZ2FyZHMsDQotLQ0KVGF0c3VvIElzaGlpDQpTUkEgT1NTIEsuSy4N CkVuZ2xpc2g6IGh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwL2luZGV4X2VuLw0KSmFwYW5lc2U6aHR0 cDovL3d3dy5zcmFvc3MuY28uanANCg0KPiBIaSBUYXRzdW8sDQo+IA0KPiBUaGFuayB5b3UgZm9y IHRoZSBub3RlcyAtIHBsZWFzZSBmaW5kIGF0dGFjaGVkIGFuIHVwZGF0ZWQgdmVyc2lvbi4NCj4g DQo+IFdoYXQgZG8geW91IHRoaW5rPw0KPiANCj4gVGhhbmtzLA0KPiANCj4gT24gTW9uLCBBdWcg MjUsIDIwMjUgYXQgNToxOOKAr0FNIFRhdHN1byBJc2hpaSA8aXNoaWlAcG9zdGdyZXNxbC5vcmc+ IHdyb3RlOg0KPiANCj4+IEhpIE5hZGF2LA0KPj4NCj4+IFRoYW5rIHlvdSBmb3IgdGhlIHBhdGNo IQ0KPj4NCj4+IEkgaGF2ZSBvbmUgcXVlc3Rpb24uIEhvdyBkbyB5b3UgcHJvdmlkZSBhIHBhc3N3 b3JkIChzcl9jaGVja19wYXNzd29yZCkNCj4+IHdoaWxlIGV4ZWN1dGluZyByZXBsaWNhdGlvbl9k ZWxheV9zb3VyY2VfY21kIGFzIHNyX2NoZWNrX3VzZXI/IEluIG15DQo+PiB1bmRlcnN0YW5kaW5n IHJlcGxpY2F0aW9uX2RlbGF5X3NvdXJjZV9jbWQgaXMgZXhlY3V0ZWQgdGhyb3VnaCBzdQ0KPj4g Y29tbWFuZCBpbiB5b3VyIHBhdGNoLiBJbiB0aGlzIGNhc2Ugc3UgY29tbWFuZCB0cmllcyB0byBy ZWFkIHRoZQ0KPj4gcGFzc3dvcmQgZnJvbSB0ZXJtaW5hbC4gSSBkb24ndCBzZWUgc3VjaCBhIGNv ZGUgaW4gdGhlIHBhdGNoLg0KPj4NCj4+IEJUVywgSSBzdGFydCB0byB0aGluayB0aGF0IGV4ZWN1 dGluZyByZXBsaWNhdGlvbl9kZWxheV9zb3VyY2VfY21kIGFzDQo+PiBzcl9jaGVja191c2VyIG1p Z2h0IG5vdCBiZSBhIGdvb2QgaWRlYS4gc3JfY2hlY2tfdXNlciBpcyBhIGRhdGFiYXNlDQo+PiB1 c2VyLCBub3QgT1MgdXNlci4gSW4gUG9zdGdyZVNRTCB0aGV5IGFyZSBub3QgbmVjZXNzYXJpbHkg dGhlDQo+PiBzYW1lLiBBbHNvIGRvaW5nIHN1IGluIHBncG9vbCBwcm9jZXNzIG5lZWRzIHRvIGJl IHZlcnkgY2FyZWZ1bGx5IHRvDQo+PiBhdm9pZCB2dWxuZXJhYmlsaXR5LiBQcm9iYWJseSB3ZSBq dXN0IGV4ZWN1dGUgaXQgYXMgcGdwb29sIE9TIHVzZXI/DQo+Pg0KPj4gTGFzdGx5IHdoZW4gSSBh cHBseSB0aGUgcGF0Y2hlcyB1c2luZyBnaXQgYXBwbHksIHRoZXJlIGFyZSBzb21lDQo+PiB0cmFp bGluZyBzcGFjZSBlcnJvcnMuDQo+Pg0KPj4gJCBnaXQgYXBwbHkgfi9leHRlcm5hbC1sYWctZmVh dHVyZS1pbXBsZW1lbnRhdGlvbi5wYXRjaA0KPj4gL2hvbWUvdC1pc2hpaS9leHRlcm5hbC1sYWct ZmVhdHVyZS1pbXBsZW1lbnRhdGlvbi5wYXRjaDozMTQ6IHRyYWlsaW5nDQo+PiB3aGl0ZXNwYWNl Lg0KPj4NCj4+IC9ob21lL3QtaXNoaWkvZXh0ZXJuYWwtbGFnLWZlYXR1cmUtaW1wbGVtZW50YXRp b24ucGF0Y2g6MzE3OiB0cmFpbGluZw0KPj4gd2hpdGVzcGFjZS4NCj4+DQo+PiAvaG9tZS90LWlz aGlpL2V4dGVybmFsLWxhZy1mZWF0dXJlLWltcGxlbWVudGF0aW9uLnBhdGNoOjMxODogdHJhaWxp bmcNCj4+IHdoaXRlc3BhY2UuDQo+PiAgICAgICAgICAgICAgICAgICAgICAgICBjbWRfbGVuID0g c3RybGVuKGVzY2FwZWRfY21kKSArDQo+PiAvaG9tZS90LWlzaGlpL2V4dGVybmFsLWxhZy1mZWF0 dXJlLWltcGxlbWVudGF0aW9uLnBhdGNoOjMyMDogdHJhaWxpbmcNCj4+IHdoaXRlc3BhY2UuDQo+ Pg0KPj4gL2hvbWUvdC1pc2hpaS9leHRlcm5hbC1sYWctZmVhdHVyZS1pbXBsZW1lbnRhdGlvbi5w YXRjaDozMjI6IHRyYWlsaW5nDQo+PiB3aGl0ZXNwYWNlLg0KPj4gICAgICAgICAgICAgICAgICAg ICAgICAgc25wcmludGYoZnVsbF9jb21tYW5kLCBjbWRfbGVuLCAic3UgLSAlcyAtYyAnJXMnIiwN Cj4+IHdhcm5pbmc6IHNxdWVsY2hlZCA0IHdoaXRlc3BhY2UgZXJyb3JzDQo+PiB3YXJuaW5nOiA5 IGxpbmVzIGFkZCB3aGl0ZXNwYWNlIGVycm9ycy4NCj4+DQo+PiAkIGdpdCBhcHBseSB+L2V4dGVy bmFsLWxhZy1mZWF0dXJlLXRlc3RzLnBhdGNoDQo+PiAvaG9tZS90LWlzaGlpL2V4dGVybmFsLWxh Zy1mZWF0dXJlLXRlc3RzLnBhdGNoOjg3OiB0cmFpbGluZyB3aGl0ZXNwYWNlLg0KPj4gLSB0ZXN0 X3BhcnNpbmcuc2g6IFVuaXQgdGVzdCBmb3IgcGFyc2luZyBsb2dpYw0KPj4gL2hvbWUvdC1pc2hp aS9leHRlcm5hbC1sYWctZmVhdHVyZS10ZXN0cy5wYXRjaDo0NDA6IHRyYWlsaW5nIHdoaXRlc3Bh Y2UuDQo+PiAjIFRlc3QgMjogRmxvYXQgdmFsdWVzDQo+PiB3YXJuaW5nOiAyIGxpbmVzIGFkZCB3 aGl0ZXNwYWNlIGVycm9ycy4NCj4+DQo+PiBBbHNvIEkgaGF2ZSBzb21lIGNvbXBpbGF0aW9uIGVy cm9ycyBhZnRlciBwYXRjaGluZyB0aGUgc291cmNlDQo+PiBjb2RlLiBTZWUgYXR0YWNoZWQgY29t cGlsYXRpb24gbG9nLg0KPj4NCj4+IEJlc3QgcmVnYXJkcywNCj4+IC0tDQo+PiBUYXRzdW8gSXNo aWkNCj4+IFNSQSBPU1MgSy5LLg0KPj4gRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAv aW5kZXhfZW4vDQo+PiBKYXBhbmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0KPj4NCj4gDQo+ IA0KPiAtLSANCj4gTmFkYXYgU2hhdHoNCj4gVGFpbG9yIEJyYW5kcyB8IENUTw0K