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.96) (envelope-from ) id 1vd0n9-00Cz1L-2N for pgpool-hackers@arkaria.postgresql.org; Tue, 06 Jan 2026 06:43:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vd0n8-006giT-2C for pgpool-hackers@arkaria.postgresql.org; Tue, 06 Jan 2026 06:43:43 +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.96) (envelope-from ) id 1vd0n8-006giM-1b for pgpool-hackers@lists.postgresql.org; Tue, 06 Jan 2026 06:43:43 +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 1vd0n6-004orb-0Y for pgpool-hackers@lists.postgresql.org; Tue, 06 Jan 2026 06:43:43 +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=TAL8w2jUffqFpVFPCWJXibtmyykmska82hXjTFBBfDo=; b=OJYBTVzua9gABTAwVQ9KA8sTnR mLVIt7fpXoQgR9ZiUyTsKfzxuQacCQneePlQJVxwGItVYfrUK/8/AhBinHQcJjlkJHwL9tXd7Ck6w zw+utX+p0cAVuvqjki0YvEuUraQ5CODJdgwBtCsQI6ANG+8DsHlxIoO5o36UimvZFoVUAK7JhKKdZ L+YtB7Pu9r60Q8/5nbyYrdAWI+K4JFnhNx5tK6t9IEwu73JAh8Q/uS6QVMsGhAl4CNF9miPUqerrR YVkv3DudPxaI1ghWFFSzMJTU5FDZKh80obfzEwc2vFe73NT3Zmi0Cg8lVqSO3zUhpNpt4xUoh8pXq udEehjfg==; Received: from [2409:11:4120:300:a6d4:bb4c:f55b:ed92] (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 1vd0my-009jVE-1t; Tue, 06 Jan 2026 06:43:35 +0000 Date: Tue, 06 Jan 2026 15:43:20 +0900 (JST) Message-Id: <20260106.154320.1734616587238293334.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: <20260106.134808.2204131019902796784.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:a6d4:bb4c:f55b:ed92 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBUaGFua3MgYSBsb3QhIExvb2tpbmcgZm9yIHRoZSBtZXJnZS4NCg0KSSBoYXZlIGp1c3QgcHVz aGVkIHRoZSBwYXRjaC4gVGhhbmsgeW91IGZvciB0aGUgZ3JlYXQgd29yayENCg0KPiBJ4oCZbGwg c3RhcnQgd29ya2luZyBvbiB0aGUgc3VnZ2VzdGlvbiBmb3IgdGhlIG5leHQgc3RhZ2UuIEhvcGVm dWxseSBpdOKAmWxsIGJlDQo+IHF1aWNrZXIgbm93IHRoYXQgSSBoYXZlIHRoZSBkZXYgZW52IGJl dHRlciBzZXR1cA0KPg0KPiBOYWRhdiBTaGF0eg0KPiBUYWlsb3IgQnJhbmRzIHwgQ1RPDQoNCkxv b2tpbmcgZm93YXJkIHRvIHNlZWluZyBuZXcgcGF0Y2ghDQoNCkJlc3QgcmVnYXJkcywNCi0tDQpU YXRzdW8gSXNoaWkNClNSQSBPU1MgSy5LLg0KRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28u anAvaW5kZXhfZW4vDQpKYXBhbmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0KDQo+IE9uIFR1 ZSwgSmFuIDYsIDIwMjYgYXQgNjo0OOKAr0FNIFRhdHN1byBJc2hpaSA8aXNoaWlAcG9zdGdyZXNx bC5vcmc+IHdyb3RlOg0KPiANCj4+ID4gVGhhbmsgeW91IHNvIG11Y2ggZm9yIHRoZSBoZWxwIHdp dGggdGhpcyEgQW5kIGZvciB0aGUgc3VnZ2VzdGlvbnMuDQo+PiA+DQo+PiA+IExldOKAmXMgY2hh bmdlIHRoZSBkb2N1bWVudCB0byBtYXRjaCB0aGVuIGltcGxlbWVudGF0aW9uIGluIHRoaXMgY2Fz ZS4NCj4+ID4gU2hvdWxkIEkgc2hhcmUgYW4gdXBkYXRlZCBwYXRjaCBvciB3aWxsIHlvdSBtb2Rp ZnkgaXQgb24gbWVyZ2U/DQo+Pg0KPj4gSSB3aWxsIG1vZGlmeSBpdCBvbiBtZXJnZS4gTm8gc3dl YXIuDQo+Pg0KPj4gQmVzdCByZWdhcmRzLA0KPj4gLS0NCj4+IFRhdHN1byBJc2hpaQ0KPj4gU1JB IE9TUyBLLksuDQo+PiBFbmdsaXNoOiBodHRwOi8vd3d3LnNyYW9zcy5jby5qcC9pbmRleF9lbi8N Cj4+IEphcGFuZXNlOmh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwDQo+Pg0KPj4gPiBOYWRhdiBTaGF0 eg0KPj4gPiBUYWlsb3IgQnJhbmRzIHwgQ1RPDQo+PiA+DQo+PiA+DQo+PiA+IE9uIFR1ZSwgSmFu IDYsIDIwMjYgYXQgMTo1OeKAr0FNIFRhdHN1byBJc2hpaSA8aXNoaWlAcG9zdGdyZXNxbC5vcmc+ DQo+PiB3cm90ZToNCj4+ID4NCj4+ID4+IEFuZC4uLiBhdHRhY2hlZCBpcyB0aGUgSmFwYW5lc2Ug ZG9jdW1lbnQuIEZvciB0aG9zZSB3aG8gYXJlIGludGVyZXN0ZWQuDQo+PiA+PiAtLQ0KPj4gPj4g VGF0c3VvIElzaGlpDQo+PiA+PiBTUkEgT1NTIEsuSy4NCj4+ID4+IEVuZ2xpc2g6IGh0dHA6Ly93 d3cuc3Jhb3NzLmNvLmpwL2luZGV4X2VuLw0KPj4gPj4gSmFwYW5lc2U6aHR0cDovL3d3dy5zcmFv c3MuY28uanANCj4+ID4+DQo+PiA+PiA+PiBUaGFua3MgZm9yIHRoZSBoZWxwISBwbGVhc2UgZmlu ZCBhdHRhY2hlZCB0aGUgbGF0ZXN0IHZlcnNpb24gd2l0aCBhbGwNCj4+ID4+ID4+IGNoYW5nZXMg YW5kIHRlc3QgcGFzc2luZy4NCj4+ID4+ID4NCj4+ID4+ID4gVGhhbmtzIGZvciB1cGRhdGluZyBw YXRjaCEgSSBjb25maXJtZWQgdGhhdCBhbGwgdGVzdCBoYXZlIHBhc3NlZCBvbiBteQ0KPj4gPj4g PiBVYnVudSBib3guICBOb3cgSSBhbSB3b3JraW5nIG9uIEphcGFuZXNlIGRvY3VtZW50LiBXaGls ZSB3b3JraW5nIG9uDQo+PiA+PiA+IGl0LCBJIGRpZCBmb2xsb3dpbmdzIHRvIHRoZSBFbmdsaXNo IGRvY3VtZW50LiAoc2VlIGF0dGFjaGVkKQ0KPj4gPj4gPg0KPj4gPj4gPiAtIFJlZm9ybWF0IGl0 IHNvIHRoYXQgZWFjaCBsaW5lIGlzIG5vdCB0b28gbG9uZy4gTGlrZSBQb3N0Z3JlU1FMLCBJDQo+ PiA+PiA+ICAgYmVuZCBlYWNoIGxpbmUgYXQgbW9zdCA3OCBjaGFycy4gKEkga25vdyBvdGhlciBw YXJ0cyBvZiBkb2N1bWVudCBkbw0KPj4gPj4gPiAgIG5vdCBmb2xsb3cgdGhlIHJ1bGUgYnV0IEkg ZG8gbm90IHdhbnQgdG8gYWRkIG1vcmUgbGluZXMgbm90DQo+PiA+PiA+ICAgZm9sbG93aW5nIHRo ZSBydWxlKS4NCj4+ID4+ID4NCj4+ID4+ID4gLSBNb3ZlIHJlcGxpY2F0aW9uX2RlbGF5X3NvdXJj ZV9jbWQgKHN0cmluZykgYW5kDQo+PiA+PiA+ICAgcmVwbGljYXRpb25fZGVsYXlfc291cmNlX3Rp bWVvdXQgKGludGVnZXIpIGF0IHRoZSBib3R0b20gb2YNCj4+ID4+ID4gICAiNS4xMi4gU3RyZWFt aW5nIFJlcGxpY2F0aW9uIENoZWNrIiBzZWN0aW9uLiBXZSB1c3VhbGx5IGFkZCB0aGUgbmV3DQo+ PiA+PiA+ICAgcGFyYW1ldGVycyBhdCB0aGUgYm90dG9tIG9mIHRoZSBwYWdlIGlmIHRoZXJlJ3Mg bm8gcGFydGljdWxhcg0KPj4gPj4gPiAgIHJlYXNvbi4gUHJldmlvdXNseSB0aGV5IHdlcmUgaW4g YmV0d2VlbiBwcmVmZXJfbG93ZXJfZGVsYXlfc3RhbmRieQ0KPj4gPj4gPiAgIGFuZCBsb2dfc3Rh bmRieV9kZWxheS4NCj4+ID4+ID4NCj4+ID4+ID4gLSBBZGQgZm9sbG93aW5nIHRvIHJlcGxpY2F0 aW9uX2RlbGF5X3NvdXJjZV9jbWQuICAiVGhlIGxpbmUgY2FuIGJlDQo+PiA+PiA+ICAgdGVybWlu YXRlZCB3aXRoIG9yIHdpdGhvdXQgYSBuZXcgbGluZSBjaGFyYWN0ZXIuIiBUaGlzIGlzIG9ic2Vy dmVkDQo+PiA+PiA+ICAgZnJvbSB0aGUgaW1wbGVtZW50YXRpb24uIEkgYmVsaWV2ZSB0aGlzIG1h dHRlcnMgZm9yIHRob3NlIHdobyB0cnkgdG8NCj4+ID4+ID4gICBpbXBsZW1lbnQgcmVwbGljYXRp b25fZGVsYXlfc291cmNlX2NtZC4NCj4+ID4+ID4NCj4+ID4+ID4gTGFzdGx5IEkgaGF2ZSBvbmUg cXVlc3Rpb24uDQo+PiA+PiA+DQo+PiA+PiA+IHJlcGxpY2F0aW9uX2RlbGF5X3NvdXJjZV90aW1l b3V0IChpbnRlZ2VyKQ0KPj4gPj4gPg0KPj4gPj4gPiAgICAgU3BlY2lmaWVzIHRoZSB0aW1lb3V0 IGluIHNlY29uZHMgZm9yIHRoZSBleHRlcm5hbCBjb21tYW5kDQo+PiA+PiA+ICAgICBzcGVjaWZp ZWQgYnkgcmVwbGljYXRpb25fZGVsYXlfc291cmNlX2NtZC4gSWYgdGhlIGNvbW1hbmQgZG9lcyBu b3QNCj4+ID4+ID4gICAgIGZpbmlzaCB3aXRoaW4gdGhlIHRpbWVvdXQsIFBncG9vbC1JSSBsb2dz IGFuIGVycm9yIGFuZCBjb250aW51ZXMNCj4+ID4+ID4gICAgIHVzaW5nIHRoZSBidWlsdC1pbiBt ZXRob2QuDQo+PiA+PiA+DQo+PiA+PiA+IEl0IHNlZW1zIHRoaXMgKCJjb250aW51ZXMgdXNpbmcg dGhlIGJ1aWx0LWluIG1ldGhvZCIpIGlzIGRpZmZlcmVudA0KPj4gPj4gPiBmcm9tIHRoZSBhY3R1 YWwgYmVoYXZpb3IuIEl0IHNlZW1zIHRoYXQgYWZ0ZXIgdGltZW91dCwgdGhlIGV4dGVybmFsDQo+ PiA+PiA+IGNvbW1hbmQgaXMgdHJpZWQgYW5kIHRpbWVvdXQuLi4uIERvIHlvdSB3YW50IHRvIGZp eCB0aGUgc291cmNlIGNvZGUgdG8NCj4+ID4+ID4gbWF0Y2ggd2l0aCB0aGUgZG9jdW1lbnQ/IE9y IGNoYW5nZSAoanVzdCByZW1vdmUgIiJjb250aW51ZXMgdXNpbmcgdGhlDQo+PiA+PiA+IGJ1aWx0 LWluIG1ldGhvZCIpIHRoZSBkb2N1bWVudD8gSSBhbSBmaW5lIHdpdGggY2hhbmdpbmcgdGhlIGRv Y3VtZW50Lg0KPj4gPj4gPg0KPj4gPj4gPiBCZXN0IHJlZ2FyZHMsDQo+PiA+PiA+IC0tDQo+PiA+ PiA+IFRhdHN1byBJc2hpaQ0KPj4gPj4gPiBTUkEgT1NTIEsuSy4NCj4+ID4+ID4gRW5nbGlzaDog aHR0cDovL3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4vDQo+PiA+PiA+IEphcGFuZXNlOmh0dHA6 Ly93d3cuc3Jhb3NzLmNvLmpwDQo+PiA+Pg0KPj4NCg==