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 1up2ST-00F5Lp-Ns for pgpool-hackers@arkaria.postgresql.org; Thu, 21 Aug 2025 10:23:51 +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 1up2SR-00FlrS-PQ for pgpool-hackers@arkaria.postgresql.org; Thu, 21 Aug 2025 10:23:48 +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 1up2SR-00FlrK-IX for pgpool-hackers@lists.postgresql.org; Thu, 21 Aug 2025 10:23:48 +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 1up2SP-0014le-04 for pgpool-hackers@lists.postgresql.org; Thu, 21 Aug 2025 10:23:47 +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=jj3vGGODV7BzQwvayZeUJdpGJNsxhhozQgVKk2bxSz0=; b=BrQC1VfkzGaHJ8H1cWlLPWuVqg smUpehdNB8wf+1EktvAF1rTQX7A5K+jA5uXe7/zvxSKwZM4A8u1YXdJ2iw13CRK1ia8yC6cWcAnhN ag/f6hxy15Z6UkqV4pcXEpKka1mLJUc+oBdV1QVfgKTIjgut+ikgudXljpTCcciDS5TqAvhyGgDzD 8VcVP5GFuyPFLkjrDznKzY7+qRluEjfl8PkiqrHXbz6P/rnCSIz3X9NBBGBWHdaO29tPEIQgBnmse BY+KDT7eKTh2+KwlP/WVk3YPoWJealpK8jyZBAtYTLFfZo79L18qvrsHaMWpTSSpXOWzHSgBhdKdS sKO8YlLA==; Received: from [2409:11:4120:300:f55e:9879:514f:315b] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256 (Exim 4.96) (envelope-from ) id 1up2SK-002PzG-30; Thu, 21 Aug 2025 10:23:44 +0000 Date: Thu, 21 Aug 2025 19:23:32 +0900 (JST) Message-Id: <20250821.192332.768193620076940871.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: <20250821.140434.533994102324088664.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:f55e:9879:514f:315b (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgTmFkYXYsDQoNClRoYW5rIHlvdSBmb3IgdW5kZXJzdGFuZGluZy4gUGxlYXNlIGRvbid0IGhl c2l0YXRlIHRvIGFzayBxdWVzdGlvbnMNCnJlZ2FyZGluZyBQZ3Bvb2wtSUkgc291cmNlIGNvZGUu DQoNCkJlc3QgcmVnYXJkcywNCi0tDQpUYXRzdW8gSXNoaWkNClNSQSBPU1MgSy5LLg0KRW5nbGlz aDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4vDQpKYXBhbmVzZTpodHRwOi8vd3d3 LnNyYW9zcy5jby5qcA0KDQo+IEhpIFRhdHN1bywNCj4gDQo+IEknbSBmaW5lIHdpdGggYWxsIG9m IHlvdXIgY29tbWVudHMgYW5kIHN1Z2dlc3Rpb25zLg0KPiANCj4gSSdsbCB3b3JrIG9uIGEgcGF0 Y2ggYW5kIHdlIGNhbiBpdGVyYXRlIG92ZXIgaXQuDQo+IA0KPiBIb3BlIHRoYXQncyBva2F5Lg0K PiANCj4gQmVzdCwNCj4gDQo+IE9uIFRodSwgQXVnIDIxLCAyMDI1IGF0IDg6MDTigK9BTSBUYXRz dW8gSXNoaWkgPGlzaGlpQHBvc3RncmVzcWwub3JnPiB3cm90ZToNCj4gDQo+PiBIaSBOYWRhdiwN Cj4+DQo+PiA+IEhpIFRhdHN1bywNCj4+ID4NCj4+ID4gVGhhbmsgeW91IGZvciB5b3VyIHJlcGx5 LCBJIGFncmVlIHdpdGggeW91ciBhcHByb2FjaC4gQmV0dGVyIHRvIGdldCAoMSkNCj4+IG91dA0K Pj4gPiBvZiB0aGUgd2F5IGZpcnN0Lg0KPj4gPg0KPj4gPiBBcyBhIHNpbXBsZXN0IGFwcHJvYWNo IHRoYXQgd2UgY2FuIGltcGxlbWVudCB0aGF0IHdvdWxkIHN1cHBvcnQNCj4+IGNvbXBsZXRlbHkN Cj4+ID4gb2ZmbG9hZGluZyB0aGUgcmVzcG9uc2liaWxpdHkgb2YgdGhlIGxhZyBjaGVja2luZyB3 ZSBjYW4gc2V0IGl0IHRvIOKAnGZpbGXigJ0NCj4+ID4gYW5kIGFkZCBhbm90aGVyIGNvbmZpZyBm b3IgZmlsZSBwYXRoLiBPciBqdXN0IGlmIHN0YXJ0cyB3aXRoIOKAnGZpbGU64oCdDQo+PiBpdOKA mWxsDQo+PiA+IHVuZGVyc3RhbmQuDQo+Pg0KPj4gTXkgY29uY2VybiBhYm91dCB0aGUgImZpbGU6 IiBhcHByb2FjaCBpcywgcmFjZSBjb25kaXRpb24uIFdoYXQgaWYNCj4+IHBncG9vbCByZWFkcyB0 aGUgZmlsZSB3aGlsZSBpdCBpcyBiZWluZyB1cGRhdGVkIGJ5IHNvbWVvbmUgZWxzZT8gIEFsc28N Cj4+IEkgdGhpbmsgdGhlIGNvbW1hbmQgYXBwcm9hY2ggaXMgbW9yZSBmbGV4aWJsZSBhbmQgZ2Vu ZXJpYy4gRm9yDQo+PiBleGFtcGxlLCB0aGUgImZpbGUgYXBwcm9jaCIgY2FuIGJlIGVhc2lseSBz aW11bGF0ZWQgYnkgc2V0dGluZyB0aGUNCj4+IGNvbW1hbmQgIi91c3IvYmluL2NhdCBwYXRoX3Rv X3RoZV9maWxlIi4NCj4+DQo+PiA+IFRoZW4gdGhlIGludGVybmFsIHBvbGxpbmcgY2FuIGp1c3Qg cmVhZCB0aGUgZmlsZSBvbiBzY2hlZHVsZS4gVGhlIGVudGlyZQ0KPj4gPiB1cGRhdGluZyBtZWNo YW5pc20gd2lsbCBiZSBsZWZ0IHRvIHRoZSBleHRlcm5hbCBzZXJ2aWNlLg0KPj4NCj4+IEludGVy bmFsIHBvbGxpbmcgaXMgYSBsaXR0bGUgYml0IGNvbXBsaWNhdGVkIGFuZCB3aWxsIG5vdCBiZSBl YXNpbHkNCj4+IGNoYW5nZWQgdG8ganVzdCByZWFkaW5nIGEgZmlsZS4gVGhlIGludGVybmFsIHBv bGxpbmcgaGFzIHR3byBvcHRpb25zOg0KPj4gb25lIGlzIGNoZWNraW5nIFdBTCBMU04gZGlmZmVy ZW5jZSwgdGhlIG90aGVyIGlzIHJlcGxpY2F0aW9uIGRlbGF5IGluDQo+PiB0aW1lLiBUaGUgZmls ZSBhcHByb2NoIHdvdWxkIG9ubHkgcmVwbGFjZSB0aGUgbGF0dGVyLiBJIHN1Z2dlc3QgdG8NCj4+ IGxlYXZlIHRoZSBpbnRlcm5hbCBwb2xsaW5nIGNvZGUgYXMgaXQgaXMuDQo+Pg0KPj4gPiBIYXZp bmcgdGhpcyBhcyBhIGZpcnN0IHN0ZXAgYWxzbyBvcGVucyB1cCB0aGUgZG9vciBmb3Igb3RoZXIN Cj4+ID4gaW1wbGVtZW50YXRpb25zLg0KPj4gPg0KPj4gPiBBbm90aGVyIGNsYXNzaWMgb3B0aW9u IHdvdWxkIGJlIGNhbGxpbmcgYW4gQVBJIGVuZHBvaW50LiBCdXQgdGhhdCBtaWdodA0KPj4gPiBj b21lIHdpdGggYSBsb3QgbW9yZSBidWxrIGFuZCBzZWN1cml0eSBjb25jZXJucy4NCj4+DQo+PiBJ IGFncmVlIHRoYXQgY2FsbGluZyBBUEkgY291bGQgYnJpbmcgc2VjdXJpdHkgY29uY2VybnMuDQo+ Pg0KPj4gQlRXLCBpbiB0aGUgY29tbWFuZCBhcHByb2NoLCB0aGUgY29tbWFuZCBzaG91bGQgYmUg ZXhlY3V0ZWQgYXMNCj4+IHNyX2NoZWNrX3VzZXIuDQo+Pg0KPj4gPiBJIHN1Z2dlc3QgSSB3b3Jr IG9uIGEgcGF0Y2ggZm9yIGZpbGUgc3VwcG9ydC4NCj4+ID4NCj4+ID4gV2hhdCBkbyB5b3UgdGhp bms/DQo+Pg0KPj4gRm9yIHRoZSByZWFzb24gYWJvdmUgSSBwcmVmZXIgdGhlIGNvbW1hbmQgYXBw cm9jaCwgbm90IHRoZSBmaWxlDQo+PiBzdXBwb3J0Lg0KPj4NCj4+ID4gTmFkYXYgU2hhdHoNCj4+ ID4gVGFpbG9yIEJyYW5kcyB8IENUTw0KPj4gPg0KPj4gPg0KPj4gPiBPbiBXZWQsIEF1ZyAyMCwg MjAyNSBhdCAzOjQ14oCvUE0gVGF0c3VvIElzaGlpIDxpc2hpaUBwb3N0Z3Jlc3FsLm9yZz4NCj4+ IHdyb3RlOg0KPj4gPg0KPj4gPj4gSGkgTmFkYXYsDQo+PiA+Pg0KPj4gPj4gVGhhbmsgeW91IGZv ciB0aGUgYW5zd2VyLg0KPj4gPj4NCj4+ID4+IEkgdGhpbmsgeW91ciBwcm9wb3NhbCBhY3R1YWxs eSBpbmNsdWRlcyB0d28gb3J0aG9nb25hbCBwcm9wb3NhbHMuDQo+PiA+Pg0KPj4gPj4gKDEpICJp bmplY3QiIHJlcGxpY2F0aW9uIGRlbGF5IHZhbHVlIGZyb20gZXh0ZXJuYWwgc291cmNlIChpbiB5 b3VyDQo+PiA+PiBjYXNlIGZyb20gQXVyb3JhKS4NCj4+ID4+DQo+PiA+PiAoMikgcGVyIHJlbGF0 aW9uIHJlY2VudCBhY2Nlc3MgYmFzZWQgcm91dGluZy4NCj4+ID4+DQo+PiA+PiBJIHN1Z2dlc3Qg dG8gaW1wbGVtZW50ICgxKSBmaXJzdCwgdGhlbiAoMikuIFRoaXMgaW5jcmVtZW50YWwgYXBwcm9h Y2gNCj4+ID4+IHdvdWxkIGJlIGVhc2llciB0aGFuIGltcGxlbWVudGluZyAoMSkrKDIpIGF0IG9u Y2UuDQo+PiA+Pg0KPj4gPj4gRm9yICgxKSB3ZSBjb3VsZCBhZGQgbmV3IHBncG9vbC5jb25mIHBh cmFtZXRlciwgc2F5DQo+PiA+PiAicmVwbGljYXRpb25fZGVsYXlfc291cmNlIi4gSWYgaXQgaXMg c2V0IHRvICJidWlsdGluIiwgdGhlbg0KPj4gPj4gcmVwbGljYXRpb24gZGVsYXkgc291cmNlIGlz IFBvc3RncmVTUUwgYXMgd2UgYWxyZWFkeSBkb2VzIHRvZGF5LiBJZg0KPj4gPj4gaXQncyBzZXQg b3RoZXIgdGhhbiAiYnVpbHRpbiIsIHRoZW4gaXQncyBhbiBleHRlcm5hbCBjb21tYW5kIG5hbWUg KCsNCj4+ID4+IGFyZ3VtZW50cykgdG8gYmUgZXhlY3V0ZWQgdG8gaW1wb3J0IHJlcGxpY2F0aW9u IGRlbGF5IHZhbHVlLiBUaGUNCj4+ID4+IGNvbW1hbmQgc2hvdWxkIHJldHVybiByZXBsaWNhdGlv biBkZWxheSB2YWx1ZSByZXByZXNlbnRlZCBpbiBzdHJpbmdzDQo+PiA+PiBsaWtlICIwIDIwIDEw Iiwgd2hpY2ggbWVhbnMgbm9kZSAwLCAxIGFuZCAyIHJlcGxpY2F0aW9uIGRlbGF5IHZhbHVlcw0K Pj4gPj4gaW4gbWlsbGlzZWNvbmQgKGluIHRoaXMgY2FzZSBzaW5jZSB0aGUgbm9kZSAwIGlzIHBy aW1hcnksIGl0cw0KPj4gPj4gcmVwbGljYXRpb24gZGVsYXkgaXMgMCkuIFRoZSBjb21tYW5kIHdp bGwgYmUgaW52b2tlZCBldmVyeQ0KPj4gPj4gc3JfY2hlY2tfcGVyaW9kLg0KPj4gPj4NCj4+ID4+ IEkgYW0gbm90IHN1cmUgaWYgdGhpcyBhY3R1YWxseSB3b3JrcyBpbiBBdXJvcmEuIFRoaXMgaXMg anVzdCBhIHF1aWNrDQo+PiA+PiBpZGVhLg0KPj4gPj4NCj4+ID4+ICgyKSB3b3VsZCBiZSBwcm9i YWJseSBtdWNoIGhhcmRlciB0aGFuICgxKS4gU28gd2UgbmVlZCBtb3JlIGRpc2N1c3Npb24NCj4+ ID4+IGxhdGVyIG9uLg0KPj4gPj4NCj4+ID4+IEJlc3QgcmVnYXJkcywNCj4+ID4+IC0tDQo+PiA+ PiBUYXRzdW8gSXNoaWkNCj4+ID4+IFNSQSBPU1MgSy5LLg0KPj4gPj4gRW5nbGlzaDogaHR0cDov L3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4vDQo+PiA+PiBKYXBhbmVzZTpodHRwOi8vd3d3LnNy YW9zcy5jby5qcA0KPj4gPj4NCj4+DQo+IA0KPiANCj4gLS0gDQo+IE5hZGF2IFNoYXR6DQo+IFRh aWxvciBCcmFuZHMgfCBDVE8NCg==