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 1uvaaT-00Fp2Z-SH for pgpool-hackers@arkaria.postgresql.org; Mon, 08 Sep 2025 12:03:10 +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 1uvaaT-004MTN-20 for pgpool-hackers@arkaria.postgresql.org; Mon, 08 Sep 2025 12:03:09 +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 1uvaaS-004MTF-RV for pgpool-hackers@lists.postgresql.org; Mon, 08 Sep 2025 12:03:09 +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 1uvaaQ-0019X1-10 for pgpool-hackers@lists.postgresql.org; Mon, 08 Sep 2025 12:03:08 +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=KUuksnr4qifuy5Cgu3i/2GLP2ZQ6IOeTxdQW/jnZLjg=; b=HqccNuvmnxPVs7Tgzuzg5xBihw 2v/JUAmacPjXis042i+I+rqWImxhHy23tUpswrEizXY6w7lc4ZobFbuhxsrEt2KcAmeufib/UFYXg Uw4TPDk6mo6OQKlw8C65GHsa0n1P/BXFLrIf6c/ENZav1mYCb/1C6rfic7OJitZLiMYmwK73rOm+4 Y6nyVDgopjPzLaPuq2UBrDuRsu58bt6RMnqtmIE7r19O+PnEBiWeld1XiqEkAWb2yFKhIv4UVcIoW ncpREmkD76WteEfsjajzwRxi0ZLo8N8TKKJg0xTy1s9xmrC869GU80mS+GZRNd4gP9qQ+cYL+t9OR ZMj/ueZQ==; Received: from [2409:11:4120:300:1ee4:6efb:25fe:62f8] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uvaaL-002gj4-2t; Mon, 08 Sep 2025 12:03:05 +0000 Date: Mon, 08 Sep 2025 21:02:52 +0900 (JST) Message-Id: <20250908.210252.248806675014934998.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: <20250908.092628.942175382089863152.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 29.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:1ee4:6efb:25fe:62f8 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgTmFkYXYsDQoNCldvdywgdGhhdCdzIHF1aWNrIQ0KSSB3aWxsIGxvb2sgaW50byB0aGUgcGF0 Y2ggdG9tb3Jyb3cuDQoNCj4gSGkgVGF0c3VvLA0KPiANCj4gUGxlYXNlIGZpbmQgYXR0YWNoZWQg dGhlIDMgcGF0Y2ggZmlsZXMgKGltcGxlbWVudGF0aW9uLCB0ZXN0cywgZG9jcykgd2l0aA0KPiB0 aGUgdXBkYXRlcyB3ZSBkaXNjdXNzZWQuDQo+IA0KPiBXaGF0IGRvIHlvdSB0aGluaz8NCj4gDQo+ IEJlc3QsDQo+IA0KPiBPbiBNb24sIFNlcCA4LCAyMDI1IGF0IDM6MjbigK9BTSBUYXRzdW8gSXNo aWkgPGlzaGlpQHBvc3RncmVzcWwub3JnPiB3cm90ZToNCj4gDQo+PiBIaSBOYWRhdiwNCj4+DQo+ PiA+IEhpIFRhdHN1bywNCj4+ID4NCj4+ID4gVGhhbmtzIGZvciBnZXR0aW5nIGJhY2sgdG8gbWUu IExldCBtZSBjbGFyaWZ5IHRoZSBvcmRlcmluZyBjb25jZXJuIGFuZA0KPj4gPiBwcm92aWRlIGFu IGV4YW1wbGUgdG8gbWFrZSBpdCBjbGVhcmVyOg0KPj4gPg0KPj4gPiBDdXJyZW50bHksIHJlcGxp Y2F0aW9uX2RlbGF5X3NvdXJjZV9jbWQgZXhlY3V0ZXMgd2l0aG91dCBhd2FyZW5lc3Mgb2YgdGhl DQo+PiA+IHJlcGxpY2EgbGlzdCBvciB0aGUgb3JkZXIgaW4gd2hpY2ggUGdwb29sIGxvYWRzIHRo ZW0uIEZvciBBdXJvcmEsIHNpbmNlDQo+PiA+IHdl4oCZcmUgYnlwYXNzaW5nIHRoZSBpbnRlcm5h bCBEQiB0YWJsZXMgYW5kIGZldGNoaW5nIGxhZyBkYXRhIGRpcmVjdGx5IHZpYQ0KPj4gPiB0aGUg QVdTIENsb3VkV2F0Y2ggQVBJLCB3ZSBuZWVkIHRvIGVuc3VyZSB0aGUgcmV0dXJuZWQgbGFnIHZh bHVlcyBhcmUNCj4+ID4gbWFwcGVkIHRvIHRoZSBjb3JyZWN0IGluc3RhbmNlcy4NCj4+ID4NCj4+ ID4gRm9yIGV4YW1wbGUsIGFzc3VtZSBQZ3Bvb2wgaGFzIHRoZSBmb2xsb3dpbmcgY29uZmlndXJh dGlvbjoNCj4+ID4NCj4+ID4gcHJpbWFyeTogZGItcHJpbWFyeQ0KPj4gPiByZXBsaWNhczogZGIt cmVwbGljYS1hLCBkYi1yZXBsaWNhLWIsIGRiLXJlcGxpY2EtYw0KPj4gPg0KPj4gPiBJZiB0aGUg Y29tbWFuZCByZXRyaWV2ZXMgbGFnIHZhbHVlcyBbMTUsIDEyMCwgNjBdIGZyb20gQ2xvdWRXYXRj aCwgd2UNCj4+IG5lZWQNCj4+ID4gdG8gZ3VhcmFudGVlIHRoZXNlIGFyZSBjb25zaXN0ZW50bHkg bWFwcGVkIGFzOg0KPj4gPg0KPj4gPg0KPj4gPiAgICAtDQo+PiA+DQo+PiA+ICAgIGRiLXJlcGxp Y2EtYSDihpIgMTVtcw0KPj4gPiAgICAtDQo+PiA+DQo+PiA+ICAgIGRiLXJlcGxpY2EtYiDihpIg MTIwbXMNCj4+ID4gICAgLQ0KPj4gPg0KPj4gPiAgICBkYi1yZXBsaWNhLWMg4oaSIDYwbXMNCj4+ ID4NCj4+ID4gV2l0aG91dCBleHBsaWNpdGx5IHBhc3NpbmcgdGhlIGluc3RhbmNlIGlkZW50aWZp ZXJzIGFuZCB0aGVpciBvcmRlciB0bw0KPj4gdGhlDQo+PiA+IGNvbW1hbmQsIHRoZXJl4oCZcyBh IHJpc2sgdGhhdCBtaXNtYXRjaGVkIG9yZGVyaW5nIHdpbGwgY2F1c2UgUGdwb29sIHRvDQo+PiBt YWtlDQo+PiA+IGluY29ycmVjdCByb3V0aW5nIGRlY2lzaW9ucy4NCj4+ID4NCj4+ID4gVG8gYWRk cmVzcyB0aGlzLCBJIHN1Z2dlc3QgZXh0ZW5kaW5nIHJlcGxpY2F0aW9uX2RlbGF5X3NvdXJjZV9j bWQgdG8NCj4+IGFjY2VwdA0KPj4gPiBhbiBvcmRlcmVkIGxpc3Qgb2YgaW5zdGFuY2UgaWRlbnRp ZmllcnMgYXMgYXJndW1lbnRzLiBUaGlzIHdheSwgdGhlDQo+PiBjb21tYW5kDQo+PiA+IGNhbiBm ZXRjaCB0aGUgbWV0cmljcyBpbiB0aGUgc2FtZSBzZXF1ZW5jZSBQZ3Bvb2wgZXhwZWN0cywgZW5z dXJpbmcNCj4+ID4gYWxpZ25tZW50IGJldHdlZW4gY29uZmlndXJhdGlvbiBhbmQgcmV0dXJuZWQg ZGF0YS4NCj4+DQo+PiBUaGFua3MgZm9yIHRoZSBjbGFyaWZpY2F0aW9uLiBQcmV2aW91c2x5IEkg bWlzdW5kZXJzdG9vZCB0aGF0IEF1cm9yYQ0KPj4gb25seSBwcm92aWRlcyAicmVhZGVyIGVuZHBv aW50Iiwgd2hpY2ggbWFkZSBtZSB0aGluayB5b3VyIHByb3Bvc2FsIHRvDQo+PiBiZSBpbXBvc3Np YmxlLiBCdXQgYWZ0ZXIgc29tZSByZXNlYXJjaCAsIEkgZm91bmQgdGhhdCBBdXJvcmEgYWxzbw0K Pj4gcHJvdmlkZXMgImNsdXN0ZXIgZW5kcG9pbnQiIHdoaWNoIHJlZmVycyB0byBlYWNoIHJlcGxp Y2EgaW5zdGFuY2UuICBTbw0KPj4gbGV0IG1lIGNoZWNrIGlmIG15IHVuZGVyc3RhbmRpbmcgaXMN Cj4+IGNvcnJlY3QuIHJlcGxpY2F0aW9uX2RlbGF5X3NvdXJjZV9jbWQgd2lsbCBiZSBpbnZva2Vk IGFzOg0KPj4NCj4+IHJlcGxpY2F0aW9uX2RlbGF5X3NvdXJjZV9jbWQgZGItcmVwbGljYS1hIGRi LXJlcGxpY2EtYiBkYi1yZXBsaWNhLWMNCj4+DQo+PiA+IFdvdWxkIHlvdSBhZ3JlZSB0aGlzIGFw cHJvYWNoIG1ha2VzIHNlbnNlPw0KPj4NCj4+IFllcy4NCj4+DQo+PiA+IElmIHNvLCBJIGNhbiBw cm92aWRlIGFuIHVwZGF0ZWQNCj4+ID4gcGF0Y2ggdG8gZGVtb25zdHJhdGUgaG93IHRoZSBjb21t YW5kIHdvdWxkIGhhbmRsZSBvcmRlcmVkIGluc3RhbmNlDQo+PiBtYXBwaW5nLg0KPj4NCj4+IFRo YW5rcy4gVGhhdCB3b3VsZCBiZSBnb29kLg0KPj4NCj4+IEJUVywgVGhlcmUgYXJlIG1pbm9yIHBv aW50cyByZWdhcmRpbmcgeW91ciBwcmV2aW91cyBwYXRjaC4gSW4gdGhlIHBhdGNoDQo+Pg0KPj4g MDgzLmV4dGVybmFsX3JlcGxpY2F0aW9uX2RlbGF5Lw0KPj4NCj4+IGlzIHRoZSB0ZXN0IGRpcmVj dG9yeS4gVGhpcyBkb2VzIG5vdCBmaXQgaW4gd2l0aCBvdXIgdGVzdA0KPj4gaW5mcmFzdHJ1Y3R1 cmUgdHJhZGl0aW9uLiBUZXN0cyBmb3IgbmV3IGZlYXR1cmVzIHNob3VsZCBiZSBhZGRlZA0KPj4g YmV0d2VlbiAwMDEgYW5kIDA0OS4gMDUwIGFuZCBncmVhdGVyIGFyZSByZXNlcnZlZCBmb3IgdGVz dHMgZm9yIGJ1Zw0KPj4gZml4ZXMuIFNvIGF0IHRoaXMgcG9pbnQsIDA0MSBpcyBhcHByb3ByZWF0 ZSAoaWYgb3RoZXIgdGVzdCBmb3IgYSBuZXcNCj4+IGZlYXR1cmUgaXMgYWRkZWQgYmVmb3JlIHlv dXIgcGF0Y2ggaXMgY29tbWl0dGVkLCB5b3UgbmVlZCB0byBhZGp1c3QNCj4+IHRoZSBudW1iZXIg b2YgY291cnNlKS4NCj4+DQo+PiBZb3UgbmVlZCB0byBpbmNsdWRlIGEgcGF0Y2ggZm9yIGRvY3Vt ZW50YXRpb24uIFlvdSBkb24ndCBuZWVkIHRvIHdyaXRlDQo+PiBKYXBhbmVzZSBkb2MgKGRvYy5q YSkuIFdlIHdpbGwgY3JlYXRlIGl0IGZyb20gdGhlIEVuZ2xpc2ggZG9jdW1lbnQNCj4+IGxhdGVy IG9uLg0KPj4NCj4+IEJlc3QgcmVnYXJkcywNCj4+IC0tDQo+PiBUYXRzdW8gSXNoaWkNCj4+IFNS QSBPU1MgSy5LLg0KPj4gRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4v DQo+PiBKYXBhbmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0KPj4NCj4gDQo+IA0KPiAtLSAN Cj4gTmFkYXYgU2hhdHoNCj4gVGFpbG9yIEJyYW5kcyB8IENUTw0K