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 1utDES-002qbb-FU for pgpool-hackers@arkaria.postgresql.org; Mon, 01 Sep 2025 22:42:37 +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 1utDDS-001IjN-Py for pgpool-hackers@arkaria.postgresql.org; Mon, 01 Sep 2025 22:41:35 +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 1utDDS-001IjD-D3 for pgpool-hackers@lists.postgresql.org; Mon, 01 Sep 2025 22:41:35 +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 1utDDQ-000469-2b for pgpool-hackers@lists.postgresql.org; Mon, 01 Sep 2025 22:41:33 +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=KwSLs+I0/fHzVP656xEe0lx1zx4qaKfDfogN+4uoZBY=; b=u/NxJWCLMPPEc1UTACtzqe0E4t SdVY+Tdnv/CZIshu8genuIe3+kGlVAhHbc1w7nM3L0h9HI0qRHgPD7Zz71bopwtX+Em+jvOeeQkgX hId5krN95TiD2cPNqFBlZsfQFHFqbVcJMXb5AfctMwdRJjo9GCIYa05OTN9WdaQ1HAsaOOfJrvOMw erb7hA7HcTQKrrskpY0quN6jEz31qBPSKBS6bF1DgJiuRalJ7xmvlDB82GNCVrMN60+EnqHy0iiFl 2XKDAnmSityEuN9knhsoB8+mDuwRW0Xs9vq5E35SxEqs5PFOUzgFnVxK3xVLbR+GHJQ9SnhhKgprf k4xQWQ7w==; Received: from [2409:11:4120:300:a831:b3f:2ff8:2790] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256 (Exim 4.96) (envelope-from ) id 1utDDL-000BHN-2R; Mon, 01 Sep 2025 22:41:31 +0000 Date: Tue, 02 Sep 2025 07:41:18 +0900 (JST) Message-Id: <20250902.074118.343005423574242823.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: <20250826.104155.1065705000208094250.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 26.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:a831:b3f:2ff8:2790 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgTmFkYXYsDQoNClNvcnJ5IGZvciBsYXRlIHJlcGx5Lg0KDQo+PiBJIGhhdmVu4oCZdCB0cmll ZCBpdCB5ZXQgYnV0IHRoZSB3aG9sZSBwcmVtaXNlIG9mIGhhdmluZyBpdCBydW4gYSBjb21tYW5k IGlzDQo+PiB0aGF0IGl04oCZcyBub3QgZGVwZW5kZW50IG9uIHRoZSBzcGVjaWZpYyBEQi4gQXMg eW91IG1lbnRpb25lZCBlYXJsaWVyLg0KPj4NCj4+IFRoZSBpc3N1ZSBibG9ja2luZyB0aGUgcmVn dWxhciBsYWcgZXh0cmFjdGlvbiBmcm9tIGF1cm9yYSBpcyB0aGF0IGl0DQo+PiBkb2VzbuKAmXQg dXBkYXRlIHRoZSB0YWJsZXMgaW4gdGhlIERCLiBJdCBkb2VzIGhhdmUgYSBDbG91ZFdhdGNoIEFQ SSB0byBnZXQNCj4+IHRoZSBudW1iZXJzIHRoby4NCg0KSSBhbSBub3QgZmFtaWxpYXIgd2l0aCBD bG91ZFdhdGNoIEFQSSBhbmQgYW0gbm90IHN1cmUgSSBmdWxseQ0KdW5kZXJzdGFuZCB5b3UgaXNz dWUuIFdoYXQgaXMgeW91ciBpc3N1ZSB3aXRoIENsb3VkV2F0Y2ggQVBJPyAgSXMgaXQgYQ0KdGVj aG5pY2FsIHByb2JsZW0sIG9yIHNvbWUgY29zdCBpc3N1ZSAoSSBndWVzcyBDbG91ZFdhdGNoIGlz IGEgcGFpZA0Kc2VydmljZSk/DQoNCj4+IE9yZGVyaW5nIGhlcmUgY291bGQgZ2V0IHRyaWNreSBz aW5jZSB3ZSBjb3VwbGUgdGhlIGNvbW1hbmQgd2l0aCB0aGUNCj4+IGluc3RhbmNlIG9yZGVyLg0K Pj4NCj4+IE1heWJlIHdlIGNhbiBleHBhbmQgdGhlIGNvbW1hbmQgdG8gcmVjZWl2ZSBzb21lIGFy Z3VtZW50cyBhcyB0byBpbnN0YW5jZQ0KPj4gb3JkZXIuDQoNCkNhbiB5b3UgZWxhYm9yYXRlIHdo YXQgIm9yZGVyaW5nIiBpcz8NCg0KQmVzdCByZWdhcmRzLA0KLS0NClRhdHN1byBJc2hpaQ0KU1JB IE9TUyBLLksuDQpFbmdsaXNoOiBodHRwOi8vd3d3LnNyYW9zcy5jby5qcC9pbmRleF9lbi8NCkph cGFuZXNlOmh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwDQoNCj4gSGkgVGF0c3VvLA0KPiANCj4gSSBk b24ndCB3YW50IHRvIHJ1c2ggYXQgYWxsIC0gZGlkIHlvdSBnZXQgYSBjaGFuY2UgdG8gbG9vayBh dCB3aGF0IEkgc2VudD8NCj4gQ2FuIEkgc2hhcmUgbW9yZSByZWxldmFudCBpbmZvcm1hdGlvbiB3 aXRoIHlvdT8NCj4gDQo+IFdoYXQgZG8geW91IHRoaW5rPw0KPiANCj4gT24gVHVlLCBBdWcgMjYs IDIwMjUgYXQgOTo1NOKAr0FNIE5hZGF2IFNoYXR6IDxuYWRhdkB0YWlsb3JicmFuZHMuY29tPiB3 cm90ZToNCj4gDQo+PiBIaSBUYXRzdW8sDQo+Pg0KPj4gSSBoYXZlbuKAmXQgdHJpZWQgaXQgeWV0 IGJ1dCB0aGUgd2hvbGUgcHJlbWlzZSBvZiBoYXZpbmcgaXQgcnVuIGEgY29tbWFuZCBpcw0KPj4g dGhhdCBpdOKAmXMgbm90IGRlcGVuZGVudCBvbiB0aGUgc3BlY2lmaWMgREIuIEFzIHlvdSBtZW50 aW9uZWQgZWFybGllci4NCj4+DQo+PiBUaGUgaXNzdWUgYmxvY2tpbmcgdGhlIHJlZ3VsYXIgbGFn IGV4dHJhY3Rpb24gZnJvbSBhdXJvcmEgaXMgdGhhdCBpdA0KPj4gZG9lc27igJl0IHVwZGF0ZSB0 aGUgdGFibGVzIGluIHRoZSBEQi4gSXQgZG9lcyBoYXZlIGEgQ2xvdWRXYXRjaCBBUEkgdG8gZ2V0 DQo+PiB0aGUgbnVtYmVycyB0aG8uDQo+Pg0KPj4gWW91IGNhbiBzZWUgdGhlIG1ldHJpYyBBdXJv cmFSZXBsaWNhTGFnIHVuZGVyDQo+Pg0KPj4gaHR0cHM6Ly9kb2NzLmF3cy5hbWF6b24uY29tL0Ft YXpvblJEUy9sYXRlc3QvQXVyb3JhVXNlckd1aWRlL21ldHJpY3MtcmVmZXJlbmNlLmh0bWwNCj4+ DQo+PiBTbyBpZiB3ZSBoYXZlIGEgc2ltcGxlIGNvbW1hbmQgdG8gZWl0aGVyIGdldCBpdCBvciBo YXZlIHNvbWV0aGluZyBlbHNlDQo+PiB1cGRhdGUgYSBmaWxlIHdpdGggdGhlIG51bWJlcnMgYmFz ZWQgb24gaXQgd2XigJlsbCBiZSBmaW5lLg0KPj4NCj4+IE9yZGVyaW5nIGhlcmUgY291bGQgZ2V0 IHRyaWNreSBzaW5jZSB3ZSBjb3VwbGUgdGhlIGNvbW1hbmQgd2l0aCB0aGUNCj4+IGluc3RhbmNl IG9yZGVyLg0KPj4NCj4+IE1heWJlIHdlIGNhbiBleHBhbmQgdGhlIGNvbW1hbmQgdG8gcmVjZWl2 ZSBzb21lIGFyZ3VtZW50cyBhcyB0byBpbnN0YW5jZQ0KPj4gb3JkZXIuDQo+Pg0KPj4gV2hhdCBk byB5b3UgdGhpbms/DQo+Pg0KPj4NCj4+IE5hZGF2IFNoYXR6DQo+PiBUYWlsb3IgQnJhbmRzIHwg Q1RPDQo+Pg0KPj4NCj4+IE9uIFR1ZSwgQXVnIDI2LCAyMDI1IGF0IDQ6NDLigK9BTSBUYXRzdW8g SXNoaWkgPGlzaGlpQHBvc3RncmVzcWwub3JnPiB3cm90ZToNCj4+DQo+Pj4gSGkgTmFkYXYsDQo+ Pj4NCj4+PiBUaGFuayB5b3UgZm9yIHVwZGF0aW5nIHRoZSBwYXRjaC4gSSB3aWxsIGxvb2sgaW50 byB0aGF0Lg0KPj4+DQo+Pj4gSSBoYXZlIGEgcXVlc3Rpb24uIEhhdmUgeW91IGFjdHVhbGx5IHRy aWVkIHRoZSBwYXRjaCB3aXRoIEFXUyBBdXJvcmE/DQo+Pj4gSSBhbSB3b25kZXJpbmcgaG93IHBh dGNoZWQgcGdwb29sIHdvcmtzIHdpdGggQXVyb3JhLiBJIGFtIGFza2luZw0KPj4+IGJlY2F1c2Ug aW4gdGhlIGRvYyAiOC41LiBBdXJvcmEgQ29uZmlndXJhdGlvbiBFeGFtcGxlIjoNCj4+Pg0KPj4+ ICBTZXQgc3JfY2hlY2tfcGVyaW9kIHRvIDAgdG8gZGlzYWJsZSBzdHJlYW1pbmcgcmVwbGljYXRp b24gZGVsYXkNCj4+PiAgY2hlY2tpbmcuIFRoaXMgaXMgYmVjYXVzZSBBdXJvcmEgZG9lcyBub3Qg cHJvdmlkZSBuZWNlc3NhcnkgZnVuY3Rpb25zDQo+Pj4gIHRvIGNoZWNrIHRoZSByZXBsaWNhdGlv biBkZWxheS4NCj4+Pg0KPj4+ICBzcl9jaGVja19wZXJpb2QgPSAwDQo+Pj4NCj4+PiBTbyBzdHJl YW1pbmcgcmVwbGljYXRpb24gY2hlY2tpbmcgaXMgZGlzYWJsZWQsIGFuZCBpdCBtZWFucyB0aGF0 IHlvdXINCj4+PiBwYXRjaCBpcyBhbHNvIGVmZmVjdGl2ZWx5IGRpc2FibGVkIHRvby4NCj4+Pg0K Pj4+IEJlc3QgcmVnYXJkcywNCj4+PiAtLQ0KPj4+IFRhdHN1byBJc2hpaQ0KPj4+IFNSQSBPU1Mg Sy5LLg0KPj4+IEVuZ2xpc2g6IGh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwL2luZGV4X2VuLw0KPj4+ IEphcGFuZXNlOmh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwDQo+Pj4NCj4+PiA+IEhpIFRhdHN1bywN Cj4+PiA+DQo+Pj4gPiBUaGFuayB5b3UgZm9yIHRoZSBub3RlcyAtIHBsZWFzZSBmaW5kIGF0dGFj aGVkIGFuIHVwZGF0ZWQgdmVyc2lvbi4NCj4+PiA+DQo+Pj4gPiBXaGF0IGRvIHlvdSB0aGluaz8N Cj4+PiA+DQo+Pj4gPiBUaGFua3MsDQo+Pj4gPg0KPj4+ID4gT24gTW9uLCBBdWcgMjUsIDIwMjUg YXQgNToxOOKAr0FNIFRhdHN1byBJc2hpaSA8aXNoaWlAcG9zdGdyZXNxbC5vcmc+DQo+Pj4gd3Jv dGU6DQo+Pj4gPg0KPj4+ID4+IEhpIE5hZGF2LA0KPj4+ID4+DQo+Pj4gPj4gVGhhbmsgeW91IGZv ciB0aGUgcGF0Y2ghDQo+Pj4gPj4NCj4+PiA+PiBJIGhhdmUgb25lIHF1ZXN0aW9uLiBIb3cgZG8g eW91IHByb3ZpZGUgYSBwYXNzd29yZCAoc3JfY2hlY2tfcGFzc3dvcmQpDQo+Pj4gPj4gd2hpbGUg ZXhlY3V0aW5nIHJlcGxpY2F0aW9uX2RlbGF5X3NvdXJjZV9jbWQgYXMgc3JfY2hlY2tfdXNlcj8g SW4gbXkNCj4+PiA+PiB1bmRlcnN0YW5kaW5nIHJlcGxpY2F0aW9uX2RlbGF5X3NvdXJjZV9jbWQg aXMgZXhlY3V0ZWQgdGhyb3VnaCBzdQ0KPj4+ID4+IGNvbW1hbmQgaW4geW91ciBwYXRjaC4gSW4g dGhpcyBjYXNlIHN1IGNvbW1hbmQgdHJpZXMgdG8gcmVhZCB0aGUNCj4+PiA+PiBwYXNzd29yZCBm cm9tIHRlcm1pbmFsLiBJIGRvbid0IHNlZSBzdWNoIGEgY29kZSBpbiB0aGUgcGF0Y2guDQo+Pj4g Pj4NCj4+PiA+PiBCVFcsIEkgc3RhcnQgdG8gdGhpbmsgdGhhdCBleGVjdXRpbmcgcmVwbGljYXRp b25fZGVsYXlfc291cmNlX2NtZCBhcw0KPj4+ID4+IHNyX2NoZWNrX3VzZXIgbWlnaHQgbm90IGJl IGEgZ29vZCBpZGVhLiBzcl9jaGVja191c2VyIGlzIGEgZGF0YWJhc2UNCj4+PiA+PiB1c2VyLCBu b3QgT1MgdXNlci4gSW4gUG9zdGdyZVNRTCB0aGV5IGFyZSBub3QgbmVjZXNzYXJpbHkgdGhlDQo+ Pj4gPj4gc2FtZS4gQWxzbyBkb2luZyBzdSBpbiBwZ3Bvb2wgcHJvY2VzcyBuZWVkcyB0byBiZSB2 ZXJ5IGNhcmVmdWxseSB0bw0KPj4+ID4+IGF2b2lkIHZ1bG5lcmFiaWxpdHkuIFByb2JhYmx5IHdl IGp1c3QgZXhlY3V0ZSBpdCBhcyBwZ3Bvb2wgT1MgdXNlcj8NCj4+PiA+Pg0KPj4+ID4+IExhc3Rs eSB3aGVuIEkgYXBwbHkgdGhlIHBhdGNoZXMgdXNpbmcgZ2l0IGFwcGx5LCB0aGVyZSBhcmUgc29t ZQ0KPj4+ID4+IHRyYWlsaW5nIHNwYWNlIGVycm9ycy4NCj4+PiA+Pg0KPj4+ID4+ICQgZ2l0IGFw cGx5IH4vZXh0ZXJuYWwtbGFnLWZlYXR1cmUtaW1wbGVtZW50YXRpb24ucGF0Y2gNCj4+PiA+PiAv aG9tZS90LWlzaGlpL2V4dGVybmFsLWxhZy1mZWF0dXJlLWltcGxlbWVudGF0aW9uLnBhdGNoOjMx NDogdHJhaWxpbmcNCj4+PiA+PiB3aGl0ZXNwYWNlLg0KPj4+ID4+DQo+Pj4gPj4gL2hvbWUvdC1p c2hpaS9leHRlcm5hbC1sYWctZmVhdHVyZS1pbXBsZW1lbnRhdGlvbi5wYXRjaDozMTc6IHRyYWls aW5nDQo+Pj4gPj4gd2hpdGVzcGFjZS4NCj4+PiA+Pg0KPj4+ID4+IC9ob21lL3QtaXNoaWkvZXh0 ZXJuYWwtbGFnLWZlYXR1cmUtaW1wbGVtZW50YXRpb24ucGF0Y2g6MzE4OiB0cmFpbGluZw0KPj4+ ID4+IHdoaXRlc3BhY2UuDQo+Pj4gPj4gICAgICAgICAgICAgICAgICAgICAgICAgY21kX2xlbiA9 IHN0cmxlbihlc2NhcGVkX2NtZCkgKw0KPj4+ID4+IC9ob21lL3QtaXNoaWkvZXh0ZXJuYWwtbGFn LWZlYXR1cmUtaW1wbGVtZW50YXRpb24ucGF0Y2g6MzIwOiB0cmFpbGluZw0KPj4+ID4+IHdoaXRl c3BhY2UuDQo+Pj4gPj4NCj4+PiA+PiAvaG9tZS90LWlzaGlpL2V4dGVybmFsLWxhZy1mZWF0dXJl LWltcGxlbWVudGF0aW9uLnBhdGNoOjMyMjogdHJhaWxpbmcNCj4+PiA+PiB3aGl0ZXNwYWNlLg0K Pj4+ID4+ICAgICAgICAgICAgICAgICAgICAgICAgIHNucHJpbnRmKGZ1bGxfY29tbWFuZCwgY21k X2xlbiwgInN1IC0gJXMgLWMNCj4+PiAnJXMnIiwNCj4+PiA+PiB3YXJuaW5nOiBzcXVlbGNoZWQg NCB3aGl0ZXNwYWNlIGVycm9ycw0KPj4+ID4+IHdhcm5pbmc6IDkgbGluZXMgYWRkIHdoaXRlc3Bh Y2UgZXJyb3JzLg0KPj4+ID4+DQo+Pj4gPj4gJCBnaXQgYXBwbHkgfi9leHRlcm5hbC1sYWctZmVh dHVyZS10ZXN0cy5wYXRjaA0KPj4+ID4+IC9ob21lL3QtaXNoaWkvZXh0ZXJuYWwtbGFnLWZlYXR1 cmUtdGVzdHMucGF0Y2g6ODc6IHRyYWlsaW5nIHdoaXRlc3BhY2UuDQo+Pj4gPj4gLSB0ZXN0X3Bh cnNpbmcuc2g6IFVuaXQgdGVzdCBmb3IgcGFyc2luZyBsb2dpYw0KPj4+ID4+IC9ob21lL3QtaXNo aWkvZXh0ZXJuYWwtbGFnLWZlYXR1cmUtdGVzdHMucGF0Y2g6NDQwOiB0cmFpbGluZw0KPj4+IHdo aXRlc3BhY2UuDQo+Pj4gPj4gIyBUZXN0IDI6IEZsb2F0IHZhbHVlcw0KPj4+ID4+IHdhcm5pbmc6 IDIgbGluZXMgYWRkIHdoaXRlc3BhY2UgZXJyb3JzLg0KPj4+ID4+DQo+Pj4gPj4gQWxzbyBJIGhh dmUgc29tZSBjb21waWxhdGlvbiBlcnJvcnMgYWZ0ZXIgcGF0Y2hpbmcgdGhlIHNvdXJjZQ0KPj4+ ID4+IGNvZGUuIFNlZSBhdHRhY2hlZCBjb21waWxhdGlvbiBsb2cuDQo+Pj4gPj4NCj4+PiA+PiBC ZXN0IHJlZ2FyZHMsDQo+Pj4gPj4gLS0NCj4+PiA+PiBUYXRzdW8gSXNoaWkNCj4+PiA+PiBTUkEg T1NTIEsuSy4NCj4+PiA+PiBFbmdsaXNoOiBodHRwOi8vd3d3LnNyYW9zcy5jby5qcC9pbmRleF9l bi8NCj4+PiA+PiBKYXBhbmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0KPj4+ID4+DQo+Pj4g Pg0KPj4+ID4NCj4+PiA+IC0tDQo+Pj4gPiBOYWRhdiBTaGF0eg0KPj4+ID4gVGFpbG9yIEJyYW5k cyB8IENUTw0KPj4+DQo+Pg0KPiANCj4gLS0gDQo+IE5hZGF2IFNoYXR6DQo+IFRhaWxvciBCcmFu ZHMgfCBDVE8NCg==