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 1v0SdQ-00ERXI-TF for pgpool-hackers@arkaria.postgresql.org; Sun, 21 Sep 2025 22:34:21 +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 1v0SdN-00FuEz-VR for pgpool-hackers@arkaria.postgresql.org; Sun, 21 Sep 2025 22:34:17 +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 1v0SdN-00FuEs-Pf for pgpool-hackers@lists.postgresql.org; Sun, 21 Sep 2025 22:34:17 +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 1v0SdK-001f6Z-0I for pgpool-hackers@lists.postgresql.org; Sun, 21 Sep 2025 22:34: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=VLd26oFzw6PvvlUb248aoDdCBn82q4lwWnjNMWt6gtA=; b=TSt+RMI/PSpacvBTeMP0VVnRQU pipc0z3sSi64lg0g9/4PT4TOQZhzb1Bk94rJ82dDe7ex8NZy2C4vAoAxEJ1QWFWu+2g3I9dVHk43i OE6t35g4HkDyp1Qb0fRbA7T1Wmv5hixBDRrT6RVuHOaFXIX3u/4c0A1dG/TsWO+v52bQPDWwW99nk qoy7ANtt7WQWC277g2xSGVtcmyc1xiTI9KtCJsleWviNACbKL1LwFhITADvlI1hmHD2mClx2flSb2 3BtkmMkQN0wJmH74SkxEOg0fXeqbqbscoF4Gslsz2GFm9LkRgGmEDZ3KE6SQAO+YpjvJtJiisxRDv TLOPembQ==; Received: from [2409:11:4120:300:ec9a:afdb:c94b:9c74] (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 1v0SdG-004Seo-0n; Sun, 21 Sep 2025 22:34:12 +0000 Date: Mon, 22 Sep 2025 07:34:00 +0900 (JST) Message-Id: <20250922.073400.794497598091925011.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: <534F5F0C-708B-4DBB-AD98-101E324E5361@tailorbrands.com> References: <20250916.193012.1767059551833136064.ishii@postgresql.org> <534F5F0C-708B-4DBB-AD98-101E324E5361@tailorbrands.com> 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:ec9a:afdb:c94b:9c74 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBUaGFuayB5b3UgZm9yIHRoZSBraW5kIHdvcmRzLiBXZSBhcmUgaGF2aW5nIGEgZ3JlYXQgdGlt ZSENCg0KR2xhZCB0byBoZWFyIHRoYXQhDQoNCj4gUmVnYXJkaW5nIHRoZSBjb21tYW5kIGtub3dp bmcgYWJvdXQgdGhlIHByaW1hcnkgSSB0aGluayBpdCBpcyBzYWZlIHRvIGFzc3VtZS4NCg0KT2th eS4NCg0KPiBXZSBjYW4gc3RhcnQgdGhpcyB3YXkgYW5kIGV2b2x2ZSBpbiB0aGUgZnV0dXJlIGlm IG5lZWRlZC4NCg0KQWdyZWVkLg0KDQo+IEkgY2FuIGluY2x1ZGUgYSBub3RlIGFib3V0IGl0IGlu IHRoZSBub3RlcyB0aGF0IHRoZSBjb21tYW5kIHdpbGwgb25seSByZWNlaXZlIHRoZSBzZWNvbmRh cnkgaW5zdGFuY2VzIGFzIGFyZ3VtZW50cy4NCj4gDQo+IEFueXRoaW5nIGVsc2UgdGhhdCBjb21l cyB0byBtaW5kPw0KDQpTb3VuZHMgbGlrZSBhIHJlYXNvbmFibGUgcmVxdWlyZW1lbnQuIEFsc28g dGhlIGNvbW1hbmQgZXhjbHVkZXMgYW55DQppbnN0YW5jZSB3aGljaCBpcyBpbiBkb3duIHN0YXRl Pw0KDQpCZXN0IHJlZ2FyZHMsDQotLQ0KVGF0c3VvIElzaGlpDQpTUkEgT1NTIEsuSy4NCkVuZ2xp c2g6IGh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwL2luZGV4X2VuLw0KSmFwYW5lc2U6aHR0cDovL3d3 dy5zcmFvc3MuY28uanANCg0KPiBOYWRhdiBTaGF0eg0KPiBDVE8NCj4gDQo+PiBPbiBTZXAgMTYs IDIwMjUsIGF0IDc6MzDigK9QTSwgVGF0c3VvIElzaGlpIDxpc2hpaUBwb3N0Z3Jlc3FsLm9yZz4g d3JvdGU6DQo+PiANCj4+IO+7vw0KPj4+IA0KPj4+IEhpIFRhdHN1bywNCj4+PiANCj4+PiBTb3Jy eSBmb3IgdGhlIGxhdGUgcmVwbHkgLSBJJ20gdHJhdmVsaW5nIHdpdGggbXkgZmFtaWx5IGF0IHRo ZSBtb21lbnQgKGluDQo+Pj4gSmFwYW4gYWN0dWFsbHkpDQo+PiANCj4+IEV4Y2VsbGVudCEgSG9w ZSB5b3UgYW5kIHlvdXIgZmFtaWx5IGFyZSBzcGVuZGluZyBncmVhdCB0aW1lIGluIEphcGFuLg0K Pj4gDQo+Pj4gYW5kIG1pZ2h0IGJlIGRlbGF5ZWQgaW4gcmVzcG9uZGluZy4NCj4+IA0KPj4gTm8g cHJvYmxlbSBhdCBhbGwuIEkgdGhpbmsgeW91IHNob3VsZCBmb2N1cyBvbiB0aGUgdHJhdmVsIGF0 IHRoaXMNCj4+IG1vbWVudC4NCj4+IA0KPj4+IFJlIHlvdXIgcG9pbnRzOg0KPj4+IDEgLSB3ZSBj YW4sIGJ1dCBJIGhhdmUgdG8gc2F5IHRoYXQgYSB1c2VyIEkgdGVuZCB0byBwcmVmZXIgY29uZmln dXJhdGlvbg0KPj4+IHZhbHVlcyBub3QgaGF2ZSBhICJtYWdpYyIgdmFsdWUgdGhhdCBkb2VzIHNv bWV0aGluZyBkaWZmZXJlbnQgdGhhbiB0aGUNCj4+PiB1c3VhbCBjYXNlIGxpa2UgdGhpcyB3b3Vs ZCBjcmVhdGUuIEknZCBzdGljayB3aXRoIHdoYXQgd2UgYWxyZWFkeSBoYXZlDQo+Pj4gcGxhbm5l ZC4gaGFwcHkgdG8gaGVhciBmcm9tIG90aGVycyBvbiB0aGUgbWFpbGluZyBsaXN0IGFzIHdlbGwg b2YgY291cnNlLg0KPj4gDQo+PiBNYWtlcyBzZW5zZS4gSSB3aXRoZHJhdyBteSBwcm9wb3NhbC4N Cj4+IA0KPj4+IDIgLSBJIHRoaW5rIHdlIGNhbiBoYXZlIHRoZSBwcmltYXJ5IGFsd2F5cyBiZSB0 aGUgZmlyc3Qgb3Igd2UgY2FuDQo+Pj4gY29tcGxldGVseSByZW1vdmUgaXQgc2luY2UgaXQgbWln aHQgYmUgcmVkdW5kYW50IGFzIGl0J3MgYWx3YXlzIGdvaW5nIHRvIGJlDQo+Pj4gMC4gd2hhdCBk byB5b3UgdGhpbms/DQo+PiANCj4+IFdoYXQgSSBhbSBub3Qgc3VyZSBpcywgd2hldGhlciB3ZSBj YW4gYXNzdW1lIHRoZSBjb21tYW5kIGFsd2F5cyBrbm93cw0KPj4gd2hpY2ggaG9zdCAob3IgSVAp IGlzIHByaW1hcnk/IElmIHRoZSBhbnN3ZXIgaXMgeWVzLCB0aGVuIHdlIGNvdWxkDQo+PiBvbWl0 IHRoZSBwcmltYXJ5LiBXaGF0IGRvIHlvdSB0aGluaz8NCj4+IA0KPj4+IDMgLSBJIGFncmVlIHdp dGggeW91LCBuZXh0IHZlcnNpb24gKGFmdGVyIHdlIGNsZWFyIGV2ZXJ5dGhpbmcgZWxzZSkgd2ls bA0KPj4+IGhhdmUgb25seSBpcC9ob3N0bmFtZStwb3J0Lg0KPj4gDQo+PiBUaGFuayB5b3UgZm9y IHVuZGVyc3RhbmRpbmcuDQo+PiANCj4+PiBMZXQgbWUga25vdyB5b3VyIHRob3VnaHRzDQo+Pj4g DQo+Pj4gVGhhbmtzIQ0KPj4+IA0KPj4+PiBPbiBUdWUsIFNlcCA5LCAyMDI1IGF0IDk6NDLigK9B TSBUYXRzdW8gSXNoaWkgPGlzaGlpQHBvc3RncmVzcWwub3JnPiB3cm90ZToNCj4+Pj4gDQo+Pj4+ IEhpIE5hZGF2LA0KPj4+PiANCj4+Pj4+IEhpIFRhdHN1bywNCj4+Pj4+IA0KPj4+Pj4gUGxlYXNl IGZpbmQgYXR0YWNoZWQgdGhlIDMgcGF0Y2ggZmlsZXMgKGltcGxlbWVudGF0aW9uLCB0ZXN0cywg ZG9jcykgd2l0aA0KPj4+Pj4gdGhlIHVwZGF0ZXMgd2UgZGlzY3Vzc2VkLg0KPj4+Pj4gDQo+Pj4+ PiBXaGF0IGRvIHlvdSB0aGluaz8NCj4+Pj4gDQo+Pj4+IEkgaGF2ZW4ndCByZWFkIHRoZSBjb2Rl IGRldGFpbHMgeWV0IGJ1dCBJIGhhdmUgYSBmZXcgcXVlc3Rpb25zLg0KPj4+PiANCj4+Pj4gMSkg Q2FuIHdlIHVzZSBvbmx5IHJlcGxpY2F0aW9uX2RlbGF5X3NvdXJjZV9jbWQgYW5kIGlmIGl0J3Mg dmFsdWUgaXMNCj4+Pj4gICAnYnVpbHRpbicsIHRoZW4gd2UgdHJlYXQgaXQgYXMgcmVwbGljYXRp b25fZGVsYXlfc291cmNlID0gYnVpbHRpbj8NCj4+Pj4gICBNYXliZSB0aGlzIGlzIG1hdHRlciBv ZiB0YXN0ZSBidXQgSSB3b3VsZCBsaWtlIHRvIGtub3cgeW91cg0KPj4+PiAgIG9waW5pb24uDQo+ Pj4+IA0KPj4+PiAyKSByZXBsaWNhdGlvbl9kZWxheV9zb3VyY2VfY21kIHdpbGwgYmUgZ2l2ZW4g YW4gb3JkZXJlZCBsaXN0IG9mDQo+Pj4+ICAgaW5zdGFuY2UgaWRlbnRpZmllcnMuIEJ1dCBpdCBz ZWVtcyB0aGVyZSdzIG5vIHdheSBmb3IgdGhlIGNvbW1hbmQNCj4+Pj4gICB3aGljaCBvbmUgaXMg dGhlIHByaW1hcnkgaW5zdGFuY2UuIElzIGl0IG9rYXkgZm9yIHRoZSBjb21tYW5kPw0KPj4+PiAN Cj4+Pj4gMykgV2h5IGRvIHlvdSBoYXZlIDMga2luZCBvZiBpbnN0YW5jZSBpZGVudGlmaWVycyAo YXBwbGljYXRpb24gbmFtZSwNCj4+Pj4gICBob3N0bmFtZSAoSVApICsgcG9ydCBhbmQgbm9kZSBp ZD8gSSB0aG91Z2h0ICJob3N0bmFtZSAoSVApICsgcG9ydCINCj4+Pj4gICBpcyBzdWZmaWNpZW50 Lg0KPj4+PiANCj4+Pj4gQ29tbWVudHM/DQo+Pj4+IC0tDQo+Pj4+IFRhdHN1byBJc2hpaQ0KPj4+ PiBTUkEgT1NTIEsuSy4NCj4+Pj4gRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAvaW5k ZXhfZW4vDQo+Pj4+IEphcGFuZXNlOmh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwDQo+Pj4+IA0KPj4+ IA0KPj4+IA0KPj4+IC0tDQo+Pj4gTmFkYXYgU2hhdHoNCj4+PiBUYWlsb3IgQnJhbmRzIHwgQ1RP DQo+IA0KPiANCg==