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.96) (envelope-from ) id 1vLrJ7-00CWr3-2g for pgpool-hackers@arkaria.postgresql.org; Wed, 19 Nov 2025 23:09:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vLrJ4-00G8vJ-23 for pgpool-hackers@arkaria.postgresql.org; Wed, 19 Nov 2025 23:09:46 +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.96) (envelope-from ) id 1vLrJ4-00G8vC-1N for pgpool-hackers@lists.postgresql.org; Wed, 19 Nov 2025 23:09:46 +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 1vLrJ1-000Q9K-09 for pgpool-hackers@lists.postgresql.org; Wed, 19 Nov 2025 23:09:45 +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=dBIHrP4WEWQOlk7nJ5k+ZyaDXrxaKxH3ZsT7ZO5BkXY=; b=kZt2gTpWGIGmCweSMfJtDtrgwu ywttkoF49v/1gSHyp4qsCDcBMsLxno6MxGe0UPhK6ADfCHKFbZCGFNwWwU+VwadEIK9p1Zv5Y+3m3 P1RxPi7AE1yIiKbrCbnZFTFVUiEkKteh7hp0Y17q2Y86IbjiALccygtwjOzmjNGZOEG3Rpd/xbcPg y4o8q8FvhSAzVdF8VJRizQtLuoT8qJvP/7uAMnHYFmU7pTyPGoY888YtzU2wRUVN1hYMIeg2wZuBD RKJcX1MTyHs0ptZNGJlrut8lYnEHfnur7VpSgFTFKijiffK3ywtcXmZ1B4SwEfuVVSVkzZXuF0D6d 9ZAK1tCw==; Received: from [2409:11:4120:300:b9d0:168a:21e6:86e] (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 1vLrIx-000xOf-2l; Wed, 19 Nov 2025 23:09:42 +0000 Date: Thu, 20 Nov 2025 08:09:30 +0900 (JST) Message-Id: <20251120.080930.16399896794232732.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: <20251106.182419.823615469104357272.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:b9d0:168a:21e6:86e (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgTmFkYXYsDQoNClRoYW5rIHlvdSBmb3IgbmV3IHBhdGNoLg0KVW5mb3J0dW5hdGVseSB0aGUg cGF0Y2ggZGlkIG5vdCBhcHBseSB0byBjdXJyZW50IG1hc3Rlci4NCg0KJCBnaXQgYXBwbHkgfi8w MDAxLUZpeC1tdWx0aXBsZS1pc3N1ZXMtaW4tZXh0ZXJuYWwtcmVwbGljYXRpb24tZGVsYXktZmUu cGF0Y2ggDQplcnJvcjogcGF0Y2ggZmFpbGVkOiBzcmMvc3RyZWFtaW5nX3JlcGxpY2F0aW9uL3Bv b2xfd29ya2VyX2NoaWxkLmM6Njk0DQplcnJvcjogc3JjL3N0cmVhbWluZ19yZXBsaWNhdGlvbi9w b29sX3dvcmtlcl9jaGlsZC5jOiBwYXRjaCBkb2VzIG5vdCBhcHBseQ0KDQpNYXliZSB0aGUgcGF0 Y2ggaXMgb24gdG9wIG9mIHlvdXIgcHJldmlvdXMgcGF0Y2g/DQoNCkFsc28gSSBzdWdnZXN0IHRv IHVzZSAiLXYiIG9wdGlvbiBvZiAiZ2l0IGZvcm1hdC1wYXRjaCIgdG8gYWRkIHRoZQ0KcGF0Y2gg dmVyc2lvbiBudW1iZXIgc28gdGhhdCB3ZSBjYW4gZWFzaWx5IGtub3cgd2hpY2ggcGF0Y2ggaXMg dGhlDQpsYXRlc3QuDQoNCkJlc3QgcmVnYXJkcywNCi0tDQpUYXRzdW8gSXNoaWkNClNSQSBPU1Mg Sy5LLg0KRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4vDQpKYXBhbmVz ZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0KDQo+IEhpIFRhdHN1bywNCj4gDQo+IFBsZWFzZSBz ZWUgYXR0YWNoZWQgYW4gdXBkYXRlZCB2ZXJzaW9uLg0KPiANCj4gdGhhbmsgeW91DQo+IA0KPiBP biBGcmksIE5vdiA3LCAyMDI1IGF0IDI6MDfigK9BTSBUYXRzdW8gSXNoaWkgPGlzaGlpQHBvc3Rn cmVzcWwub3JnPiB3cm90ZToNCj4gDQo+PiA+IFNvcnJ5IGZvciB0aGF0IC0gdGhhbmtzIGZvciB0 aGUgcGF0Y2guDQo+PiA+DQo+PiA+IFBsZWFzZSBmaW5kIGF0dGFjaGVkIGEgbmV3IHZlcnNpb24N Cj4+DQo+PiBUaGFua3MgZm9yIHRoZSBuZXcgdmVyc2lvbi4gVW5mb3J0dW5hdGVseSB0aGlzIHRp bWUgcmVncmVzc2lvbiB0ZXN0DQo+PiBmYWlscyBhdDoNCj4+DQo+PiA+IFdhaXRpbmcgZm9yIGNv bW1hbmQgdGltZW91dC4uLg0KPj4gPiBmYWlsOiBjb21tYW5kIHRpbWVvdXQgbm90IGRldGVjdGVk DQo+Pg0KPj4gQXR0YWNoZWQgaXMgdGhlIHBncG9vbC5sb2cuDQo+Pg0KPj4gQmVzdCByZWdhcmRz LA0KPj4gLS0NCj4+IFRhdHN1byBJc2hpaQ0KPj4gU1JBIE9TUyBLLksuDQo+PiBFbmdsaXNoOiBo dHRwOi8vd3d3LnNyYW9zcy5jby5qcC9pbmRleF9lbi8NCj4+IEphcGFuZXNlOmh0dHA6Ly93d3cu c3Jhb3NzLmNvLmpwDQo+Pg0KPj4gPiBPbiBNb24sIE5vdiAzLCAyMDI1IGF0IDk6MDXigK9BTSBU YXRzdW8gSXNoaWkgPGlzaGlpQHBvc3RncmVzcWwub3JnPg0KPj4gd3JvdGU6DQo+PiA+DQo+PiA+ PiA+IHRoYW5rcyBhbmQgc29ycnkgZm9yIHRoZSBpc3N1ZXMsIHBsZWFzZSBmaW5kIGF0dGFjaGVk IHVwZGF0ZWQgdmVyc2lvbi4NCj4+ID4+DQo+PiA+PiBObyBwcm9ibGVtLg0KPj4gPj4NCj4+ID4+ IFRoaXMgdGltZSB0aGUgcGF0Y2ggYXBwbGllcyBmaW5lLCBubyBjb21waWxlciB3YXJuaW5ncy4g IEhvd2V2ZXIsDQo+PiA+PiByZWdyZXNzaW9uIHRlc3QgZGlkIG5vdCBwYXNzZWQgaGVyZSAob24g VWJ1bnR1IDI0IExUUyBpZiB0aGlzDQo+PiA+PiBtYXR0ZXJzKS4gIFNvIEkgbG9va2VkIGludG8N Cj4+ID4+IHNyYy90ZXN0L3JlZ3Jlc3Npb24vdGVzdHMvMDQxLmV4dGVybmFsX3JlcGxpY2F0aW9u X2RlbGF5L3Rlc3Quc2ggYQ0KPj4gPj4gbGl0dGxlIGJpdCBhbmQgYXBwbHkgYXR0YWNoZWQgcGF0 Y2ggKHRlc3Quc2gucGF0Y2gpLiBJdCBtb3ZlZCBmb3J3YXJkDQo+PiA+PiBwYXJ0aWFsbHkgYnV0 IGZhaWxlZCBhdDoNCj4+ID4+DQo+PiA+PiBmYWlsOiBjb21tYW5kIGV4ZWN1dGlvbiBmYWlsdXJl IG5vdCBkZXRlY3RlZA0KPj4gPj4NCj4+ID4+IFBsZWFzZSBmaW5kIGF0dGFjaGVkDQo+PiA+Pg0K Pj4gc3JjL3Rlc3QvcmVncmVzc2lvbi90ZXN0cy8wNDEuZXh0ZXJuYWxfcmVwbGljYXRpb25fZGVs YXkvdGVzdGRpci9wZ3Bvb2wubG9nDQo+PiA+PiBhbmQgc3JjL3Rlc3QvcmVncmVzc2lvbi9sb2cv MDQxLmV4dGVybmFsX3JlcGxpY2F0aW9uX2RlbGF5Lg0KPj4gPj4NCj4+ID4+IEJlc3QgcmVnYXJk cywNCj4+ID4+IC0tDQo+PiA+PiBUYXRzdW8gSXNoaWkNCj4+ID4+IFNSQSBPU1MgSy5LLg0KPj4g Pj4gRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4vDQo+PiA+PiBKYXBh bmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0KPj4gPj4NCj4+ID4NCj4+ID4NCj4+ID4gLS0N Cj4+ID4gTmFkYXYgU2hhdHoNCj4+ID4gVGFpbG9yIEJyYW5kcyB8IENUTw0KPj4NCj4gDQo+IA0K PiAtLSANCj4gTmFkYXYgU2hhdHoNCj4gVGFpbG9yIEJyYW5kcyB8IENUTw0K