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 1vEcLT-00EJ7I-Tg for pgpool-hackers@arkaria.postgresql.org; Thu, 30 Oct 2025 23:46:19 +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 1vEcLR-00BB64-Ko for pgpool-hackers@arkaria.postgresql.org; Thu, 30 Oct 2025 23:46:16 +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 1vEcLR-00BB5w-Cs for pgpool-hackers@lists.postgresql.org; Thu, 30 Oct 2025 23:46:16 +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 1vEcLN-0059PS-0Y for pgpool-hackers@lists.postgresql.org; Thu, 30 Oct 2025 23:46:16 +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=kb28b0k/bIugQmu+YxoBeipkA6LEAs+t4poMx0ksc3Y=; b=ayg25klvmAxBQW9Jqzou/dhrrm azZ9eUuPRNETYKGDI2RQXmQbqwY9GBymFSvYbPzj79lDVngQ7qDpLvZR3ODM2tZ/6FXAawjzm0Lsc HOjtYI7jGhaBlCpMbDpsolm7YUT13GHKtd+WvIxxuj1nsP8gqfRpJn6uEZDh4EyPQp1vBRzkODb+e kvLVD0B3zEdqc92lW2wMfFNTIf6wjKprERq+cCRSpgh38dJYAgNTdfpJwWsx6TnFZmRRQFVqFgXFw X4oBe1guPeC0+9uymQxyMklcp7OvO8OL64AeL4BrJcIIe6F5AKVXOx86d3WZrwcAgWpBakcXEZF3r 2lsXkqjw==; Received: from [2409:11:4120:300:5e69:70ae:e895:51df] (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 1vEcLI-00CJOR-1x; Thu, 30 Oct 2025 23:46:12 +0000 Date: Fri, 31 Oct 2025 08:45:26 +0900 (JST) Message-Id: <20251031.084526.310963640592087194.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: <20250930.183509.1786375391511683043.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:5e69:70ae:e895:51df (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBIaSwNCj4gDQo+IEknbSBiYWNrIGF0IHdvcmsgLSB3ZHl0IG9mIHRoaXMgdmVyc2lvbj8NCg0K VGhhbmtzIGZvciB0aGUgcGF0Y2ghIEkgd2lsbCBsb29rIGludG8gaXQgd2Vla2VuZC4NCg0KPiAo c2lkZSBub3RlIC0gSmFwYW4gd2FzIGluY3JlZGlibGUgOikpDQoNCkdsYWQgdG8gaGVhciB0aGF0 IQ0KDQo+IE9uIFR1ZSwgU2VwIDMwLCAyMDI1IGF0IDEyOjM14oCvUE0gVGF0c3VvIElzaGlpIDxp c2hpaUBwb3N0Z3Jlc3FsLm9yZz4gd3JvdGU6DQo+IA0KPj4gPiBJIHdvdWxkIGFjdHVhbGx5IHN1 Z2dlc3QgaW5jbHVkaW5nIGRvd24gc3RhdGUgaW5zdGFuY2VzIGluIGNhc2UgcGdwb29sDQo+PiA+ IGlzbuKAmXQgYXdhcmUgeWV0LiBJdCBjYW4gZXhjbHVkZSB0aGVtIG9uY2UgaXQgZG9lcy4NCj4+ ID4gRm9yIHRoZXNlIGNhc2VzIG1heWJlICAtMSA/DQo+Pg0KPj4gSSBkb24ndCB0aGluayBwZ3Bv b2wgd2lsbCB0cmlnZXIgZmFpbG92ZXIgZXZlbiBpZg0KPj4gcmVwbGljYXRpb25fZGVsYXlfc291 cmNlX2NtZCByZXR1cm5zIC0xIGZvciBzdWNoIGluc3RhbmNlIGJlY2F1c2UNCj4+IHBncG9vbCBh bHJlYWR5IGhhcyBpdHMgb3duIG1ldGhvZCB0byBkZXRlY3QgaW5zdGFuY2UgZG93biAoaS5lLiBo ZWFsdGgNCj4+IGNoZWNrKSBhbmQgbWV0aG9kIHRvIGF2b2lkIGZhbHNlIHBvc2l0aXZlDQo+PiAo aS5lLiBmYWlsb3Zlcl9yZXF1aXJlX2NvbnNlbnN1cykuDQo+Pg0KPj4gU3RpbGwgZm9yIHN1Y2gg aW5zdGFjZXMgcmVwbGljYXRpb25fZGVsYXlfc291cmNlX2NtZCByZXR1cm5zIC0xIG1heWJlDQo+ PiB1c2VmdWwgaWYgaXQncyBsb2dnZWQgZm9yIGFkbWlucy4NCj4+DQo+PiBTbyBJIGFtIE9rYXkg d2l0aCB0aGUgaWRlYS4NCj4+DQo+PiBCZXN0IHJlZ2FyZHMsDQo+PiAtLQ0KPj4gVGF0c3VvIElz aGlpDQo+PiBTUkEgT1NTIEsuSy4NCj4+IEVuZ2xpc2g6IGh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpw L2luZGV4X2VuLw0KPj4gSmFwYW5lc2U6aHR0cDovL3d3dy5zcmFvc3MuY28uanANCj4+DQo+PiA+ IE5hZGF2IFNoYXR6DQo+PiA+IFRhaWxvciBCcmFuZHMgfCBDVE8NCj4+ID4NCj4+ID4NCj4+ID4g T24gTW9uLCBTZXAgMjIsIDIwMjUgYXQgNzozNOKAr0FNIFRhdHN1byBJc2hpaSA8aXNoaWlAcG9z dGdyZXNxbC5vcmc+DQo+PiB3cm90ZToNCj4+ID4NCj4+ID4+ID4gVGhhbmsgeW91IGZvciB0aGUg a2luZCB3b3Jkcy4gV2UgYXJlIGhhdmluZyBhIGdyZWF0IHRpbWUhDQo+PiA+Pg0KPj4gPj4gR2xh ZCB0byBoZWFyIHRoYXQhDQo+PiA+Pg0KPj4gPj4gPiBSZWdhcmRpbmcgdGhlIGNvbW1hbmQga25v d2luZyBhYm91dCB0aGUgcHJpbWFyeSBJIHRoaW5rIGl0IGlzIHNhZmUgdG8NCj4+ID4+IGFzc3Vt ZS4NCj4+ID4+DQo+PiA+PiBPa2F5Lg0KPj4gPj4NCj4+ID4+ID4gV2UgY2FuIHN0YXJ0IHRoaXMg d2F5IGFuZCBldm9sdmUgaW4gdGhlIGZ1dHVyZSBpZiBuZWVkZWQuDQo+PiA+Pg0KPj4gPj4gQWdy ZWVkLg0KPj4gPj4NCj4+ID4+ID4gSSBjYW4gaW5jbHVkZSBhIG5vdGUgYWJvdXQgaXQgaW4gdGhl IG5vdGVzIHRoYXQgdGhlIGNvbW1hbmQgd2lsbCBvbmx5DQo+PiA+PiByZWNlaXZlIHRoZSBzZWNv bmRhcnkgaW5zdGFuY2VzIGFzIGFyZ3VtZW50cy4NCj4+ID4+ID4NCj4+ID4+ID4gQW55dGhpbmcg ZWxzZSB0aGF0IGNvbWVzIHRvIG1pbmQ/DQo+PiA+Pg0KPj4gPj4gU291bmRzIGxpa2UgYSByZWFz b25hYmxlIHJlcXVpcmVtZW50LiBBbHNvIHRoZSBjb21tYW5kIGV4Y2x1ZGVzIGFueQ0KPj4gPj4g aW5zdGFuY2Ugd2hpY2ggaXMgaW4gZG93biBzdGF0ZT8NCj4+ID4+DQo+PiA+PiBCZXN0IHJlZ2Fy ZHMsDQo+PiA+PiAtLQ0KPj4gPj4gVGF0c3VvIElzaGlpDQo+PiA+PiBTUkEgT1NTIEsuSy4NCj4+ ID4+IEVuZ2xpc2g6IGh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwL2luZGV4X2VuLw0KPj4gPj4gSmFw YW5lc2U6aHR0cDovL3d3dy5zcmFvc3MuY28uanANCj4+ID4+DQo+PiA+PiA+IE5hZGF2IFNoYXR6 DQo+PiA+PiA+IENUTw0KPj4gPj4gPg0KPj4gPj4gPj4gT24gU2VwIDE2LCAyMDI1LCBhdCA3OjMw 4oCvUE0sIFRhdHN1byBJc2hpaSA8aXNoaWlAcG9zdGdyZXNxbC5vcmc+DQo+PiB3cm90ZToNCj4+ ID4+ID4+DQo+PiA+PiA+PiDvu78NCj4+ID4+ID4+Pg0KPj4gPj4gPj4+IEhpIFRhdHN1bywNCj4+ ID4+ID4+Pg0KPj4gPj4gPj4+IFNvcnJ5IGZvciB0aGUgbGF0ZSByZXBseSAtIEknbSB0cmF2ZWxp bmcgd2l0aCBteSBmYW1pbHkgYXQgdGhlDQo+PiBtb21lbnQNCj4+ID4+IChpbg0KPj4gPj4gPj4+ IEphcGFuIGFjdHVhbGx5KQ0KPj4gPj4gPj4NCj4+ID4+ID4+IEV4Y2VsbGVudCEgSG9wZSB5b3Ug YW5kIHlvdXIgZmFtaWx5IGFyZSBzcGVuZGluZyBncmVhdCB0aW1lIGluIEphcGFuLg0KPj4gPj4g Pj4NCj4+ID4+ID4+PiBhbmQgbWlnaHQgYmUgZGVsYXllZCBpbiByZXNwb25kaW5nLg0KPj4gPj4g Pj4NCj4+ID4+ID4+IE5vIHByb2JsZW0gYXQgYWxsLiBJIHRoaW5rIHlvdSBzaG91bGQgZm9jdXMg b24gdGhlIHRyYXZlbCBhdCB0aGlzDQo+PiA+PiA+PiBtb21lbnQuDQo+PiA+PiA+Pg0KPj4gPj4g Pj4+IFJlIHlvdXIgcG9pbnRzOg0KPj4gPj4gPj4+IDEgLSB3ZSBjYW4sIGJ1dCBJIGhhdmUgdG8g c2F5IHRoYXQgYSB1c2VyIEkgdGVuZCB0byBwcmVmZXINCj4+ID4+IGNvbmZpZ3VyYXRpb24NCj4+ ID4+ID4+PiB2YWx1ZXMgbm90IGhhdmUgYSAibWFnaWMiIHZhbHVlIHRoYXQgZG9lcyBzb21ldGhp bmcgZGlmZmVyZW50IHRoYW4NCj4+IHRoZQ0KPj4gPj4gPj4+IHVzdWFsIGNhc2UgbGlrZSB0aGlz IHdvdWxkIGNyZWF0ZS4gSSdkIHN0aWNrIHdpdGggd2hhdCB3ZSBhbHJlYWR5DQo+PiBoYXZlDQo+ PiA+PiA+Pj4gcGxhbm5lZC4gaGFwcHkgdG8gaGVhciBmcm9tIG90aGVycyBvbiB0aGUgbWFpbGlu ZyBsaXN0IGFzIHdlbGwgb2YNCj4+ID4+IGNvdXJzZS4NCj4+ID4+ID4+DQo+PiA+PiA+PiBNYWtl cyBzZW5zZS4gSSB3aXRoZHJhdyBteSBwcm9wb3NhbC4NCj4+ID4+ID4+DQo+PiA+PiA+Pj4gMiAt IEkgdGhpbmsgd2UgY2FuIGhhdmUgdGhlIHByaW1hcnkgYWx3YXlzIGJlIHRoZSBmaXJzdCBvciB3 ZSBjYW4NCj4+ID4+ID4+PiBjb21wbGV0ZWx5IHJlbW92ZSBpdCBzaW5jZSBpdCBtaWdodCBiZSBy ZWR1bmRhbnQgYXMgaXQncyBhbHdheXMNCj4+IGdvaW5nDQo+PiA+PiB0byBiZQ0KPj4gPj4gPj4+ IDAuIHdoYXQgZG8geW91IHRoaW5rPw0KPj4gPj4gPj4NCj4+ID4+ID4+IFdoYXQgSSBhbSBub3Qg c3VyZSBpcywgd2hldGhlciB3ZSBjYW4gYXNzdW1lIHRoZSBjb21tYW5kIGFsd2F5cyBrbm93cw0K Pj4gPj4gPj4gd2hpY2ggaG9zdCAob3IgSVApIGlzIHByaW1hcnk/IElmIHRoZSBhbnN3ZXIgaXMg eWVzLCB0aGVuIHdlIGNvdWxkDQo+PiA+PiA+PiBvbWl0IHRoZSBwcmltYXJ5LiBXaGF0IGRvIHlv dSB0aGluaz8NCj4+ID4+ID4+DQo+PiA+PiA+Pj4gMyAtIEkgYWdyZWUgd2l0aCB5b3UsIG5leHQg dmVyc2lvbiAoYWZ0ZXIgd2UgY2xlYXIgZXZlcnl0aGluZyBlbHNlKQ0KPj4gPj4gd2lsbA0KPj4g Pj4gPj4+IGhhdmUgb25seSBpcC9ob3N0bmFtZStwb3J0Lg0KPj4gPj4gPj4NCj4+ID4+ID4+IFRo YW5rIHlvdSBmb3IgdW5kZXJzdGFuZGluZy4NCj4+ID4+ID4+DQo+PiA+PiA+Pj4gTGV0IG1lIGtu b3cgeW91ciB0aG91Z2h0cw0KPj4gPj4gPj4+DQo+PiA+PiA+Pj4gVGhhbmtzIQ0KPj4gPj4gPj4+ DQo+PiA+PiA+Pj4+IE9uIFR1ZSwgU2VwIDksIDIwMjUgYXQgOTo0MuKAr0FNIFRhdHN1byBJc2hp aSA8aXNoaWlAcG9zdGdyZXNxbC5vcmc+DQo+PiA+PiB3cm90ZToNCj4+ID4+ID4+Pj4NCj4+ID4+ ID4+Pj4gSGkgTmFkYXYsDQo+PiA+PiA+Pj4+DQo+PiA+PiA+Pj4+PiBIaSBUYXRzdW8sDQo+PiA+ PiA+Pj4+Pg0KPj4gPj4gPj4+Pj4gUGxlYXNlIGZpbmQgYXR0YWNoZWQgdGhlIDMgcGF0Y2ggZmls ZXMgKGltcGxlbWVudGF0aW9uLCB0ZXN0cywNCj4+IGRvY3MpDQo+PiA+PiB3aXRoDQo+PiA+PiA+ Pj4+PiB0aGUgdXBkYXRlcyB3ZSBkaXNjdXNzZWQuDQo+PiA+PiA+Pj4+Pg0KPj4gPj4gPj4+Pj4g V2hhdCBkbyB5b3UgdGhpbms/DQo+PiA+PiA+Pj4+DQo+PiA+PiA+Pj4+IEkgaGF2ZW4ndCByZWFk IHRoZSBjb2RlIGRldGFpbHMgeWV0IGJ1dCBJIGhhdmUgYSBmZXcgcXVlc3Rpb25zLg0KPj4gPj4g Pj4+Pg0KPj4gPj4gPj4+PiAxKSBDYW4gd2UgdXNlIG9ubHkgcmVwbGljYXRpb25fZGVsYXlfc291 cmNlX2NtZCBhbmQgaWYgaXQncyB2YWx1ZQ0KPj4gaXMNCj4+ID4+ID4+Pj4gICAnYnVpbHRpbics IHRoZW4gd2UgdHJlYXQgaXQgYXMgcmVwbGljYXRpb25fZGVsYXlfc291cmNlID0NCj4+IGJ1aWx0 aW4/DQo+PiA+PiA+Pj4+ICAgTWF5YmUgdGhpcyBpcyBtYXR0ZXIgb2YgdGFzdGUgYnV0IEkgd291 bGQgbGlrZSB0byBrbm93IHlvdXINCj4+ID4+ID4+Pj4gICBvcGluaW9uLg0KPj4gPj4gPj4+Pg0K Pj4gPj4gPj4+PiAyKSByZXBsaWNhdGlvbl9kZWxheV9zb3VyY2VfY21kIHdpbGwgYmUgZ2l2ZW4g YW4gb3JkZXJlZCBsaXN0IG9mDQo+PiA+PiA+Pj4+ICAgaW5zdGFuY2UgaWRlbnRpZmllcnMuIEJ1 dCBpdCBzZWVtcyB0aGVyZSdzIG5vIHdheSBmb3IgdGhlIGNvbW1hbmQNCj4+ID4+ID4+Pj4gICB3 aGljaCBvbmUgaXMgdGhlIHByaW1hcnkgaW5zdGFuY2UuIElzIGl0IG9rYXkgZm9yIHRoZSBjb21t YW5kPw0KPj4gPj4gPj4+Pg0KPj4gPj4gPj4+PiAzKSBXaHkgZG8geW91IGhhdmUgMyBraW5kIG9m IGluc3RhbmNlIGlkZW50aWZpZXJzIChhcHBsaWNhdGlvbg0KPj4gbmFtZSwNCj4+ID4+ID4+Pj4g ICBob3N0bmFtZSAoSVApICsgcG9ydCBhbmQgbm9kZSBpZD8gSSB0aG91Z2h0ICJob3N0bmFtZSAo SVApICsNCj4+IHBvcnQiDQo+PiA+PiA+Pj4+ICAgaXMgc3VmZmljaWVudC4NCj4+ID4+ID4+Pj4N Cj4+ID4+ID4+Pj4gQ29tbWVudHM/DQo+PiA+PiA+Pj4+IC0tDQo+PiA+PiA+Pj4+IFRhdHN1byBJ c2hpaQ0KPj4gPj4gPj4+PiBTUkEgT1NTIEsuSy4NCj4+ID4+ID4+Pj4gRW5nbGlzaDogaHR0cDov L3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4vDQo+PiA+PiA+Pj4+IEphcGFuZXNlOmh0dHA6Ly93 d3cuc3Jhb3NzLmNvLmpwDQo+PiA+PiA+Pj4+DQo+PiA+PiA+Pj4NCj4+ID4+ID4+Pg0KPj4gPj4g Pj4+IC0tDQo+PiA+PiA+Pj4gTmFkYXYgU2hhdHoNCj4+ID4+ID4+PiBUYWlsb3IgQnJhbmRzIHwg Q1RPDQo+PiA+PiA+DQo+PiA+PiA+DQo+PiA+Pg0KPj4NCj4gDQo+IA0KPiAtLSANCj4gTmFkYXYg U2hhdHoNCj4gVGFpbG9yIEJyYW5kcyB8IENUTw0K