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 1uySxB-008TNA-Hj for pgpool-hackers@arkaria.postgresql.org; Tue, 16 Sep 2025 10:30:29 +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 1uySx9-00H1qM-0Z for pgpool-hackers@arkaria.postgresql.org; Tue, 16 Sep 2025 10:30:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uySx8-00H1qF-PG for pgpool-hackers@lists.postgresql.org; Tue, 16 Sep 2025 10:30:27 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uySx5-0016zz-1T for pgpool-hackers@lists.postgresql.org; Tue, 16 Sep 2025 10:30:27 +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=xBVzQccAh3iuw75r9s8efbZ4tmQruMpCfibpb26LjcI=; b=wvAWP+nAPiA9PiLkHL4euKWs2h rHx0wMq7Vl3hhr2lx+1H1gXOgb4D3y7SrbbiSDWD0U98lmBTGiBGcEZXkxzku0IwQ1qsVjZ9pkVsx aGxD5Qbfa07nn/9zE7UF03qBXMX9hgMQykQAtKR/fM2st7ZAgPnxY9N8WOcjtz4HTjhbTSNXh/d7b 3fIorO0WmDvGdmOi1zgJq9w91YGUHm8yo7iB2chuaLA0ldqnMuk6IFmmVUCiJJ0tMhRnz2qEL42Rh r+hkXhWfqY8qfTFsCO/Yz5SN/+qwelMHryZeYAwBMSz7csJkRgnQdrYmzXoWKZbWarMARqPx6Erd9 UEKct/mg==; Received: from [2409:11:4120:300:c09e:3e3b:637d:657b] (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 1uySx4-002G0K-0T; Tue, 16 Sep 2025 10:30:24 +0000 Date: Tue, 16 Sep 2025 19:30:12 +0900 (JST) Message-Id: <20250916.193012.1767059551833136064.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: <20250909.093944.156562835222886259.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:c09e:3e3b:637d:657b (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBIaSBUYXRzdW8sDQo+IA0KPiBTb3JyeSBmb3IgdGhlIGxhdGUgcmVwbHkgLSBJJ20gdHJhdmVs aW5nIHdpdGggbXkgZmFtaWx5IGF0IHRoZSBtb21lbnQgKGluDQo+IEphcGFuIGFjdHVhbGx5KSAN Cg0KRXhjZWxsZW50ISBIb3BlIHlvdSBhbmQgeW91ciBmYW1pbHkgYXJlIHNwZW5kaW5nIGdyZWF0 IHRpbWUgaW4gSmFwYW4uDQoNCj4gYW5kIG1pZ2h0IGJlIGRlbGF5ZWQgaW4gcmVzcG9uZGluZy4N Cg0KTm8gcHJvYmxlbSBhdCBhbGwuIEkgdGhpbmsgeW91IHNob3VsZCBmb2N1cyBvbiB0aGUgdHJh dmVsIGF0IHRoaXMNCm1vbWVudC4NCg0KPiBSZSB5b3VyIHBvaW50czoNCj4gMSAtIHdlIGNhbiwg YnV0IEkgaGF2ZSB0byBzYXkgdGhhdCBhIHVzZXIgSSB0ZW5kIHRvIHByZWZlciBjb25maWd1cmF0 aW9uDQo+IHZhbHVlcyBub3QgaGF2ZSBhICJtYWdpYyIgdmFsdWUgdGhhdCBkb2VzIHNvbWV0aGlu ZyBkaWZmZXJlbnQgdGhhbiB0aGUNCj4gdXN1YWwgY2FzZSBsaWtlIHRoaXMgd291bGQgY3JlYXRl LiBJJ2Qgc3RpY2sgd2l0aCB3aGF0IHdlIGFscmVhZHkgaGF2ZQ0KPiBwbGFubmVkLiBoYXBweSB0 byBoZWFyIGZyb20gb3RoZXJzIG9uIHRoZSBtYWlsaW5nIGxpc3QgYXMgd2VsbCBvZiBjb3Vyc2Uu DQoNCk1ha2VzIHNlbnNlLiBJIHdpdGhkcmF3IG15IHByb3Bvc2FsLg0KDQo+IDIgLSBJIHRoaW5r IHdlIGNhbiBoYXZlIHRoZSBwcmltYXJ5IGFsd2F5cyBiZSB0aGUgZmlyc3Qgb3Igd2UgY2FuDQo+ IGNvbXBsZXRlbHkgcmVtb3ZlIGl0IHNpbmNlIGl0IG1pZ2h0IGJlIHJlZHVuZGFudCBhcyBpdCdz IGFsd2F5cyBnb2luZyB0byBiZQ0KPiAwLiB3aGF0IGRvIHlvdSB0aGluaz8NCg0KV2hhdCBJIGFt IG5vdCBzdXJlIGlzLCB3aGV0aGVyIHdlIGNhbiBhc3N1bWUgdGhlIGNvbW1hbmQgYWx3YXlzIGtu b3dzDQp3aGljaCBob3N0IChvciBJUCkgaXMgcHJpbWFyeT8gSWYgdGhlIGFuc3dlciBpcyB5ZXMs IHRoZW4gd2UgY291bGQNCm9taXQgdGhlIHByaW1hcnkuIFdoYXQgZG8geW91IHRoaW5rPw0KDQo+ IDMgLSBJIGFncmVlIHdpdGggeW91LCBuZXh0IHZlcnNpb24gKGFmdGVyIHdlIGNsZWFyIGV2ZXJ5 dGhpbmcgZWxzZSkgd2lsbA0KPiBoYXZlIG9ubHkgaXAvaG9zdG5hbWUrcG9ydC4NCg0KVGhhbmsg eW91IGZvciB1bmRlcnN0YW5kaW5nLg0KDQo+IExldCBtZSBrbm93IHlvdXIgdGhvdWdodHMNCj4g DQo+IFRoYW5rcyENCj4gDQo+IE9uIFR1ZSwgU2VwIDksIDIwMjUgYXQgOTo0MuKAr0FNIFRhdHN1 byBJc2hpaSA8aXNoaWlAcG9zdGdyZXNxbC5vcmc+IHdyb3RlOg0KPiANCj4+IEhpIE5hZGF2LA0K Pj4NCj4+ID4gSGkgVGF0c3VvLA0KPj4gPg0KPj4gPiBQbGVhc2UgZmluZCBhdHRhY2hlZCB0aGUg MyBwYXRjaCBmaWxlcyAoaW1wbGVtZW50YXRpb24sIHRlc3RzLCBkb2NzKSB3aXRoDQo+PiA+IHRo ZSB1cGRhdGVzIHdlIGRpc2N1c3NlZC4NCj4+ID4NCj4+ID4gV2hhdCBkbyB5b3UgdGhpbms/DQo+ Pg0KPj4gSSBoYXZlbid0IHJlYWQgdGhlIGNvZGUgZGV0YWlscyB5ZXQgYnV0IEkgaGF2ZSBhIGZl dyBxdWVzdGlvbnMuDQo+Pg0KPj4gMSkgQ2FuIHdlIHVzZSBvbmx5IHJlcGxpY2F0aW9uX2RlbGF5 X3NvdXJjZV9jbWQgYW5kIGlmIGl0J3MgdmFsdWUgaXMNCj4+ICAgICdidWlsdGluJywgdGhlbiB3 ZSB0cmVhdCBpdCBhcyByZXBsaWNhdGlvbl9kZWxheV9zb3VyY2UgPSBidWlsdGluPw0KPj4gICAg TWF5YmUgdGhpcyBpcyBtYXR0ZXIgb2YgdGFzdGUgYnV0IEkgd291bGQgbGlrZSB0byBrbm93IHlv dXINCj4+ICAgIG9waW5pb24uDQo+Pg0KPj4gMikgcmVwbGljYXRpb25fZGVsYXlfc291cmNlX2Nt ZCB3aWxsIGJlIGdpdmVuIGFuIG9yZGVyZWQgbGlzdCBvZg0KPj4gICAgaW5zdGFuY2UgaWRlbnRp ZmllcnMuIEJ1dCBpdCBzZWVtcyB0aGVyZSdzIG5vIHdheSBmb3IgdGhlIGNvbW1hbmQNCj4+ICAg IHdoaWNoIG9uZSBpcyB0aGUgcHJpbWFyeSBpbnN0YW5jZS4gSXMgaXQgb2theSBmb3IgdGhlIGNv bW1hbmQ/DQo+Pg0KPj4gMykgV2h5IGRvIHlvdSBoYXZlIDMga2luZCBvZiBpbnN0YW5jZSBpZGVu dGlmaWVycyAoYXBwbGljYXRpb24gbmFtZSwNCj4+ICAgIGhvc3RuYW1lIChJUCkgKyBwb3J0IGFu ZCBub2RlIGlkPyBJIHRob3VnaHQgImhvc3RuYW1lIChJUCkgKyBwb3J0Ig0KPj4gICAgaXMgc3Vm ZmljaWVudC4NCj4+DQo+PiBDb21tZW50cz8NCj4+IC0tDQo+PiBUYXRzdW8gSXNoaWkNCj4+IFNS QSBPU1MgSy5LLg0KPj4gRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4v DQo+PiBKYXBhbmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0KPj4NCj4gDQo+IA0KPiAtLSAN Cj4gTmFkYXYgU2hhdHoNCj4gVGFpbG9yIEJyYW5kcyB8IENUTw0K