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 1v3Wld-0002cA-Qy for pgpool-hackers@arkaria.postgresql.org; Tue, 30 Sep 2025 09:35: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 1v3Wlb-00869g-SV for pgpool-hackers@arkaria.postgresql.org; Tue, 30 Sep 2025 09:35:28 +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 1v3Wlb-00869M-CG for pgpool-hackers@lists.postgresql.org; Tue, 30 Sep 2025 09:35:28 +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 1v3WlZ-000fhs-0t for pgpool-hackers@lists.postgresql.org; Tue, 30 Sep 2025 09:35: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=+Jm3ht459IaNefL9APuEjqxzKv8uDQlcPyhcGEtnCds=; b=LeCMMi7hHyvTZXApRRU8E3jxm6 JKK8vVUU0jYz0vwtNTe4G5Fim705mUWDEwc2bVar6O/OUcLoA423kI0NRP9BOlSlhJtZGlCI/vR/j aolNY39ng+AD2nF2sZPaS9g+1BHgxxwtNO9MyqNZ0jHaXYW9Qtx0ommLhc3cMqt0m+CYZIStq8Bvk U02OgBwhvhOSTg5tF/tCLXhYBRsjoOSjXQKDO+OkYkPmdPw3UL2wAHSXBKIxK8DRWDBe0ZsXzza1h GttMS3XLqR9QpHpww5cHaGSnMPdc+FlG1zIzoQrxf8Cg2NpB2qzHYAUtHT/6xHL/d+Kkhfx98EPqG Cm2L1YSg==; Received: from [2409:11:4120:300:96ff:4b6b:1055:708] (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 1v3WlW-001rsl-1R; Tue, 30 Sep 2025 09:35:24 +0000 Date: Tue, 30 Sep 2025 18:35:09 +0900 (JST) Message-Id: <20250930.183509.1786375391511683043.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: <534F5F0C-708B-4DBB-AD98-101E324E5361@tailorbrands.com> <20250922.073400.794497598091925011.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:96ff:4b6b:1055:708 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBJIHdvdWxkIGFjdHVhbGx5IHN1Z2dlc3QgaW5jbHVkaW5nIGRvd24gc3RhdGUgaW5zdGFuY2Vz IGluIGNhc2UgcGdwb29sDQo+IGlzbuKAmXQgYXdhcmUgeWV0LiBJdCBjYW4gZXhjbHVkZSB0aGVt IG9uY2UgaXQgZG9lcy4NCj4gRm9yIHRoZXNlIGNhc2VzIG1heWJlICAtMSA/DQoNCkkgZG9uJ3Qg dGhpbmsgcGdwb29sIHdpbGwgdHJpZ2VyIGZhaWxvdmVyIGV2ZW4gaWYNCnJlcGxpY2F0aW9uX2Rl bGF5X3NvdXJjZV9jbWQgcmV0dXJucyAtMSBmb3Igc3VjaCBpbnN0YW5jZSBiZWNhdXNlDQpwZ3Bv b2wgYWxyZWFkeSBoYXMgaXRzIG93biBtZXRob2QgdG8gZGV0ZWN0IGluc3RhbmNlIGRvd24gKGku ZS4gaGVhbHRoDQpjaGVjaykgYW5kIG1ldGhvZCB0byBhdm9pZCBmYWxzZSBwb3NpdGl2ZQ0KKGku ZS4gZmFpbG92ZXJfcmVxdWlyZV9jb25zZW5zdXMpLg0KDQpTdGlsbCBmb3Igc3VjaCBpbnN0YWNl cyByZXBsaWNhdGlvbl9kZWxheV9zb3VyY2VfY21kIHJldHVybnMgLTEgbWF5YmUNCnVzZWZ1bCBp ZiBpdCdzIGxvZ2dlZCBmb3IgYWRtaW5zLg0KDQpTbyBJIGFtIE9rYXkgd2l0aCB0aGUgaWRlYS4N Cg0KQmVzdCByZWdhcmRzLA0KLS0NClRhdHN1byBJc2hpaQ0KU1JBIE9TUyBLLksuDQpFbmdsaXNo OiBodHRwOi8vd3d3LnNyYW9zcy5jby5qcC9pbmRleF9lbi8NCkphcGFuZXNlOmh0dHA6Ly93d3cu c3Jhb3NzLmNvLmpwDQoNCj4gTmFkYXYgU2hhdHoNCj4gVGFpbG9yIEJyYW5kcyB8IENUTw0KPiAN Cj4gDQo+IE9uIE1vbiwgU2VwIDIyLCAyMDI1IGF0IDc6MzTigK9BTSBUYXRzdW8gSXNoaWkgPGlz aGlpQHBvc3RncmVzcWwub3JnPiB3cm90ZToNCj4gDQo+PiA+IFRoYW5rIHlvdSBmb3IgdGhlIGtp bmQgd29yZHMuIFdlIGFyZSBoYXZpbmcgYSBncmVhdCB0aW1lIQ0KPj4NCj4+IEdsYWQgdG8gaGVh ciB0aGF0IQ0KPj4NCj4+ID4gUmVnYXJkaW5nIHRoZSBjb21tYW5kIGtub3dpbmcgYWJvdXQgdGhl IHByaW1hcnkgSSB0aGluayBpdCBpcyBzYWZlIHRvDQo+PiBhc3N1bWUuDQo+Pg0KPj4gT2theS4N Cj4+DQo+PiA+IFdlIGNhbiBzdGFydCB0aGlzIHdheSBhbmQgZXZvbHZlIGluIHRoZSBmdXR1cmUg aWYgbmVlZGVkLg0KPj4NCj4+IEFncmVlZC4NCj4+DQo+PiA+IEkgY2FuIGluY2x1ZGUgYSBub3Rl IGFib3V0IGl0IGluIHRoZSBub3RlcyB0aGF0IHRoZSBjb21tYW5kIHdpbGwgb25seQ0KPj4gcmVj ZWl2ZSB0aGUgc2Vjb25kYXJ5IGluc3RhbmNlcyBhcyBhcmd1bWVudHMuDQo+PiA+DQo+PiA+IEFu eXRoaW5nIGVsc2UgdGhhdCBjb21lcyB0byBtaW5kPw0KPj4NCj4+IFNvdW5kcyBsaWtlIGEgcmVh c29uYWJsZSByZXF1aXJlbWVudC4gQWxzbyB0aGUgY29tbWFuZCBleGNsdWRlcyBhbnkNCj4+IGlu c3RhbmNlIHdoaWNoIGlzIGluIGRvd24gc3RhdGU/DQo+Pg0KPj4gQmVzdCByZWdhcmRzLA0KPj4g LS0NCj4+IFRhdHN1byBJc2hpaQ0KPj4gU1JBIE9TUyBLLksuDQo+PiBFbmdsaXNoOiBodHRwOi8v d3d3LnNyYW9zcy5jby5qcC9pbmRleF9lbi8NCj4+IEphcGFuZXNlOmh0dHA6Ly93d3cuc3Jhb3Nz LmNvLmpwDQo+Pg0KPj4gPiBOYWRhdiBTaGF0eg0KPj4gPiBDVE8NCj4+ID4NCj4+ID4+IE9uIFNl cCAxNiwgMjAyNSwgYXQgNzozMOKAr1BNLCBUYXRzdW8gSXNoaWkgPGlzaGlpQHBvc3RncmVzcWwu b3JnPiB3cm90ZToNCj4+ID4+DQo+PiA+PiDvu78NCj4+ID4+Pg0KPj4gPj4+IEhpIFRhdHN1bywN Cj4+ID4+Pg0KPj4gPj4+IFNvcnJ5IGZvciB0aGUgbGF0ZSByZXBseSAtIEknbSB0cmF2ZWxpbmcg d2l0aCBteSBmYW1pbHkgYXQgdGhlIG1vbWVudA0KPj4gKGluDQo+PiA+Pj4gSmFwYW4gYWN0dWFs bHkpDQo+PiA+Pg0KPj4gPj4gRXhjZWxsZW50ISBIb3BlIHlvdSBhbmQgeW91ciBmYW1pbHkgYXJl IHNwZW5kaW5nIGdyZWF0IHRpbWUgaW4gSmFwYW4uDQo+PiA+Pg0KPj4gPj4+IGFuZCBtaWdodCBi ZSBkZWxheWVkIGluIHJlc3BvbmRpbmcuDQo+PiA+Pg0KPj4gPj4gTm8gcHJvYmxlbSBhdCBhbGwu IEkgdGhpbmsgeW91IHNob3VsZCBmb2N1cyBvbiB0aGUgdHJhdmVsIGF0IHRoaXMNCj4+ID4+IG1v bWVudC4NCj4+ID4+DQo+PiA+Pj4gUmUgeW91ciBwb2ludHM6DQo+PiA+Pj4gMSAtIHdlIGNhbiwg YnV0IEkgaGF2ZSB0byBzYXkgdGhhdCBhIHVzZXIgSSB0ZW5kIHRvIHByZWZlcg0KPj4gY29uZmln dXJhdGlvbg0KPj4gPj4+IHZhbHVlcyBub3QgaGF2ZSBhICJtYWdpYyIgdmFsdWUgdGhhdCBkb2Vz IHNvbWV0aGluZyBkaWZmZXJlbnQgdGhhbiB0aGUNCj4+ID4+PiB1c3VhbCBjYXNlIGxpa2UgdGhp cyB3b3VsZCBjcmVhdGUuIEknZCBzdGljayB3aXRoIHdoYXQgd2UgYWxyZWFkeSBoYXZlDQo+PiA+ Pj4gcGxhbm5lZC4gaGFwcHkgdG8gaGVhciBmcm9tIG90aGVycyBvbiB0aGUgbWFpbGluZyBsaXN0 IGFzIHdlbGwgb2YNCj4+IGNvdXJzZS4NCj4+ID4+DQo+PiA+PiBNYWtlcyBzZW5zZS4gSSB3aXRo ZHJhdyBteSBwcm9wb3NhbC4NCj4+ID4+DQo+PiA+Pj4gMiAtIEkgdGhpbmsgd2UgY2FuIGhhdmUg dGhlIHByaW1hcnkgYWx3YXlzIGJlIHRoZSBmaXJzdCBvciB3ZSBjYW4NCj4+ID4+PiBjb21wbGV0 ZWx5IHJlbW92ZSBpdCBzaW5jZSBpdCBtaWdodCBiZSByZWR1bmRhbnQgYXMgaXQncyBhbHdheXMg Z29pbmcNCj4+IHRvIGJlDQo+PiA+Pj4gMC4gd2hhdCBkbyB5b3UgdGhpbms/DQo+PiA+Pg0KPj4g Pj4gV2hhdCBJIGFtIG5vdCBzdXJlIGlzLCB3aGV0aGVyIHdlIGNhbiBhc3N1bWUgdGhlIGNvbW1h bmQgYWx3YXlzIGtub3dzDQo+PiA+PiB3aGljaCBob3N0IChvciBJUCkgaXMgcHJpbWFyeT8gSWYg dGhlIGFuc3dlciBpcyB5ZXMsIHRoZW4gd2UgY291bGQNCj4+ID4+IG9taXQgdGhlIHByaW1hcnku IFdoYXQgZG8geW91IHRoaW5rPw0KPj4gPj4NCj4+ID4+PiAzIC0gSSBhZ3JlZSB3aXRoIHlvdSwg bmV4dCB2ZXJzaW9uIChhZnRlciB3ZSBjbGVhciBldmVyeXRoaW5nIGVsc2UpDQo+PiB3aWxsDQo+ PiA+Pj4gaGF2ZSBvbmx5IGlwL2hvc3RuYW1lK3BvcnQuDQo+PiA+Pg0KPj4gPj4gVGhhbmsgeW91 IGZvciB1bmRlcnN0YW5kaW5nLg0KPj4gPj4NCj4+ID4+PiBMZXQgbWUga25vdyB5b3VyIHRob3Vn aHRzDQo+PiA+Pj4NCj4+ID4+PiBUaGFua3MhDQo+PiA+Pj4NCj4+ID4+Pj4gT24gVHVlLCBTZXAg OSwgMjAyNSBhdCA5OjQy4oCvQU0gVGF0c3VvIElzaGlpIDxpc2hpaUBwb3N0Z3Jlc3FsLm9yZz4N Cj4+IHdyb3RlOg0KPj4gPj4+Pg0KPj4gPj4+PiBIaSBOYWRhdiwNCj4+ID4+Pj4NCj4+ID4+Pj4+ IEhpIFRhdHN1bywNCj4+ID4+Pj4+DQo+PiA+Pj4+PiBQbGVhc2UgZmluZCBhdHRhY2hlZCB0aGUg MyBwYXRjaCBmaWxlcyAoaW1wbGVtZW50YXRpb24sIHRlc3RzLCBkb2NzKQ0KPj4gd2l0aA0KPj4g Pj4+Pj4gdGhlIHVwZGF0ZXMgd2UgZGlzY3Vzc2VkLg0KPj4gPj4+Pj4NCj4+ID4+Pj4+IFdoYXQg ZG8geW91IHRoaW5rPw0KPj4gPj4+Pg0KPj4gPj4+PiBJIGhhdmVuJ3QgcmVhZCB0aGUgY29kZSBk ZXRhaWxzIHlldCBidXQgSSBoYXZlIGEgZmV3IHF1ZXN0aW9ucy4NCj4+ID4+Pj4NCj4+ID4+Pj4g MSkgQ2FuIHdlIHVzZSBvbmx5IHJlcGxpY2F0aW9uX2RlbGF5X3NvdXJjZV9jbWQgYW5kIGlmIGl0 J3MgdmFsdWUgaXMNCj4+ID4+Pj4gICAnYnVpbHRpbicsIHRoZW4gd2UgdHJlYXQgaXQgYXMgcmVw bGljYXRpb25fZGVsYXlfc291cmNlID0gYnVpbHRpbj8NCj4+ID4+Pj4gICBNYXliZSB0aGlzIGlz IG1hdHRlciBvZiB0YXN0ZSBidXQgSSB3b3VsZCBsaWtlIHRvIGtub3cgeW91cg0KPj4gPj4+PiAg IG9waW5pb24uDQo+PiA+Pj4+DQo+PiA+Pj4+IDIpIHJlcGxpY2F0aW9uX2RlbGF5X3NvdXJjZV9j bWQgd2lsbCBiZSBnaXZlbiBhbiBvcmRlcmVkIGxpc3Qgb2YNCj4+ID4+Pj4gICBpbnN0YW5jZSBp ZGVudGlmaWVycy4gQnV0IGl0IHNlZW1zIHRoZXJlJ3Mgbm8gd2F5IGZvciB0aGUgY29tbWFuZA0K Pj4gPj4+PiAgIHdoaWNoIG9uZSBpcyB0aGUgcHJpbWFyeSBpbnN0YW5jZS4gSXMgaXQgb2theSBm b3IgdGhlIGNvbW1hbmQ/DQo+PiA+Pj4+DQo+PiA+Pj4+IDMpIFdoeSBkbyB5b3UgaGF2ZSAzIGtp bmQgb2YgaW5zdGFuY2UgaWRlbnRpZmllcnMgKGFwcGxpY2F0aW9uIG5hbWUsDQo+PiA+Pj4+ICAg aG9zdG5hbWUgKElQKSArIHBvcnQgYW5kIG5vZGUgaWQ/IEkgdGhvdWdodCAiaG9zdG5hbWUgKElQ KSArIHBvcnQiDQo+PiA+Pj4+ICAgaXMgc3VmZmljaWVudC4NCj4+ID4+Pj4NCj4+ID4+Pj4gQ29t bWVudHM/DQo+PiA+Pj4+IC0tDQo+PiA+Pj4+IFRhdHN1byBJc2hpaQ0KPj4gPj4+PiBTUkEgT1NT IEsuSy4NCj4+ID4+Pj4gRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4v DQo+PiA+Pj4+IEphcGFuZXNlOmh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwDQo+PiA+Pj4+DQo+PiA+ Pj4NCj4+ID4+Pg0KPj4gPj4+IC0tDQo+PiA+Pj4gTmFkYXYgU2hhdHoNCj4+ID4+PiBUYWlsb3Ig QnJhbmRzIHwgQ1RPDQo+PiA+DQo+PiA+DQo+Pg0K