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 1vcyzZ-00Ciex-0y for pgpool-hackers@arkaria.postgresql.org; Tue, 06 Jan 2026 04:48:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vcyzX-006J7M-1T for pgpool-hackers@arkaria.postgresql.org; Tue, 06 Jan 2026 04:48:24 +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 1vcyzX-006J7B-0K for pgpool-hackers@lists.postgresql.org; Tue, 06 Jan 2026 04:48:24 +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 1vcyzV-004o6s-0N for pgpool-hackers@lists.postgresql.org; Tue, 06 Jan 2026 04:48:23 +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=vHszbzHuKuRtrTHv9y9PNSxAJSR1Jxa2F9GeZYH+yWE=; b=TFmskyxFFkT7+yzpK1dki9lkuB yLpo3fZPKx+90lb/wKIXwXT1ReYwC6FzkqwYN8u8M2RlZeYfh7OGQUEJauXyfo0vJT8CrS/Os5Kz/ pzTGTLp36SYzy+9VpJdOJo+6dFryRR7THK2+k6amGfzqzhNjeY87bq7teISYzkjH28Lk5AyZdJVne r/dx6b7DrpkMFJWtJ/hqci/k3ONRy5JdFCv+wGZknt0UX4/Yv6DVc+Gj+VceQSXwplT4r1v4aXqcO 7N6VbTiKnklIj1lpRRNEIXeed3SWOpGOfLbG8LyvMBxkRozegzYJsbBS1Kjt44afmQMM7IPLyp9kP XvRErJbg==; 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 1vcyzS-009htc-2O; Tue, 06 Jan 2026 04:48:21 +0000 Date: Tue, 06 Jan 2026 13:48:08 +0900 (JST) Message-Id: <20260106.134808.2204131019902796784.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.085257.1146983017764501399.ishii@postgresql.org> <20260106.085931.748008649679987578.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 PiBUaGFuayB5b3Ugc28gbXVjaCBmb3IgdGhlIGhlbHAgd2l0aCB0aGlzISBBbmQgZm9yIHRoZSBz dWdnZXN0aW9ucy4NCj4gDQo+IExldOKAmXMgY2hhbmdlIHRoZSBkb2N1bWVudCB0byBtYXRjaCB0 aGVuIGltcGxlbWVudGF0aW9uIGluIHRoaXMgY2FzZS4NCj4gU2hvdWxkIEkgc2hhcmUgYW4gdXBk YXRlZCBwYXRjaCBvciB3aWxsIHlvdSBtb2RpZnkgaXQgb24gbWVyZ2U/DQoNCkkgd2lsbCBtb2Rp ZnkgaXQgb24gbWVyZ2UuIE5vIHN3ZWFyLg0KDQpCZXN0IHJlZ2FyZHMsDQotLQ0KVGF0c3VvIElz aGlpDQpTUkEgT1NTIEsuSy4NCkVuZ2xpc2g6IGh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwL2luZGV4 X2VuLw0KSmFwYW5lc2U6aHR0cDovL3d3dy5zcmFvc3MuY28uanANCg0KPiBOYWRhdiBTaGF0eg0K PiBUYWlsb3IgQnJhbmRzIHwgQ1RPDQo+IA0KPiANCj4gT24gVHVlLCBKYW4gNiwgMjAyNiBhdCAx OjU54oCvQU0gVGF0c3VvIElzaGlpIDxpc2hpaUBwb3N0Z3Jlc3FsLm9yZz4gd3JvdGU6DQo+IA0K Pj4gQW5kLi4uIGF0dGFjaGVkIGlzIHRoZSBKYXBhbmVzZSBkb2N1bWVudC4gRm9yIHRob3NlIHdo byBhcmUgaW50ZXJlc3RlZC4NCj4+IC0tDQo+PiBUYXRzdW8gSXNoaWkNCj4+IFNSQSBPU1MgSy5L Lg0KPj4gRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4vDQo+PiBKYXBh bmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0KPj4NCj4+ID4+IFRoYW5rcyBmb3IgdGhlIGhl bHAhIHBsZWFzZSBmaW5kIGF0dGFjaGVkIHRoZSBsYXRlc3QgdmVyc2lvbiB3aXRoIGFsbA0KPj4g Pj4gY2hhbmdlcyBhbmQgdGVzdCBwYXNzaW5nLg0KPj4gPg0KPj4gPiBUaGFua3MgZm9yIHVwZGF0 aW5nIHBhdGNoISBJIGNvbmZpcm1lZCB0aGF0IGFsbCB0ZXN0IGhhdmUgcGFzc2VkIG9uIG15DQo+ PiA+IFVidW51IGJveC4gIE5vdyBJIGFtIHdvcmtpbmcgb24gSmFwYW5lc2UgZG9jdW1lbnQuIFdo aWxlIHdvcmtpbmcgb24NCj4+ID4gaXQsIEkgZGlkIGZvbGxvd2luZ3MgdG8gdGhlIEVuZ2xpc2gg ZG9jdW1lbnQuIChzZWUgYXR0YWNoZWQpDQo+PiA+DQo+PiA+IC0gUmVmb3JtYXQgaXQgc28gdGhh dCBlYWNoIGxpbmUgaXMgbm90IHRvbyBsb25nLiBMaWtlIFBvc3RncmVTUUwsIEkNCj4+ID4gICBi ZW5kIGVhY2ggbGluZSBhdCBtb3N0IDc4IGNoYXJzLiAoSSBrbm93IG90aGVyIHBhcnRzIG9mIGRv Y3VtZW50IGRvDQo+PiA+ICAgbm90IGZvbGxvdyB0aGUgcnVsZSBidXQgSSBkbyBub3Qgd2FudCB0 byBhZGQgbW9yZSBsaW5lcyBub3QNCj4+ID4gICBmb2xsb3dpbmcgdGhlIHJ1bGUpLg0KPj4gPg0K Pj4gPiAtIE1vdmUgcmVwbGljYXRpb25fZGVsYXlfc291cmNlX2NtZCAoc3RyaW5nKSBhbmQNCj4+ ID4gICByZXBsaWNhdGlvbl9kZWxheV9zb3VyY2VfdGltZW91dCAoaW50ZWdlcikgYXQgdGhlIGJv dHRvbSBvZg0KPj4gPiAgICI1LjEyLiBTdHJlYW1pbmcgUmVwbGljYXRpb24gQ2hlY2siIHNlY3Rp b24uIFdlIHVzdWFsbHkgYWRkIHRoZSBuZXcNCj4+ID4gICBwYXJhbWV0ZXJzIGF0IHRoZSBib3R0 b20gb2YgdGhlIHBhZ2UgaWYgdGhlcmUncyBubyBwYXJ0aWN1bGFyDQo+PiA+ICAgcmVhc29uLiBQ cmV2aW91c2x5IHRoZXkgd2VyZSBpbiBiZXR3ZWVuIHByZWZlcl9sb3dlcl9kZWxheV9zdGFuZGJ5 DQo+PiA+ICAgYW5kIGxvZ19zdGFuZGJ5X2RlbGF5Lg0KPj4gPg0KPj4gPiAtIEFkZCBmb2xsb3dp bmcgdG8gcmVwbGljYXRpb25fZGVsYXlfc291cmNlX2NtZC4gICJUaGUgbGluZSBjYW4gYmUNCj4+ ID4gICB0ZXJtaW5hdGVkIHdpdGggb3Igd2l0aG91dCBhIG5ldyBsaW5lIGNoYXJhY3Rlci4iIFRo aXMgaXMgb2JzZXJ2ZWQNCj4+ID4gICBmcm9tIHRoZSBpbXBsZW1lbnRhdGlvbi4gSSBiZWxpZXZl IHRoaXMgbWF0dGVycyBmb3IgdGhvc2Ugd2hvIHRyeSB0bw0KPj4gPiAgIGltcGxlbWVudCByZXBs aWNhdGlvbl9kZWxheV9zb3VyY2VfY21kLg0KPj4gPg0KPj4gPiBMYXN0bHkgSSBoYXZlIG9uZSBx dWVzdGlvbi4NCj4+ID4NCj4+ID4gcmVwbGljYXRpb25fZGVsYXlfc291cmNlX3RpbWVvdXQgKGlu dGVnZXIpDQo+PiA+DQo+PiA+ICAgICBTcGVjaWZpZXMgdGhlIHRpbWVvdXQgaW4gc2Vjb25kcyBm b3IgdGhlIGV4dGVybmFsIGNvbW1hbmQNCj4+ID4gICAgIHNwZWNpZmllZCBieSByZXBsaWNhdGlv bl9kZWxheV9zb3VyY2VfY21kLiBJZiB0aGUgY29tbWFuZCBkb2VzIG5vdA0KPj4gPiAgICAgZmlu aXNoIHdpdGhpbiB0aGUgdGltZW91dCwgUGdwb29sLUlJIGxvZ3MgYW4gZXJyb3IgYW5kIGNvbnRp bnVlcw0KPj4gPiAgICAgdXNpbmcgdGhlIGJ1aWx0LWluIG1ldGhvZC4NCj4+ID4NCj4+ID4gSXQg c2VlbXMgdGhpcyAoImNvbnRpbnVlcyB1c2luZyB0aGUgYnVpbHQtaW4gbWV0aG9kIikgaXMgZGlm ZmVyZW50DQo+PiA+IGZyb20gdGhlIGFjdHVhbCBiZWhhdmlvci4gSXQgc2VlbXMgdGhhdCBhZnRl ciB0aW1lb3V0LCB0aGUgZXh0ZXJuYWwNCj4+ID4gY29tbWFuZCBpcyB0cmllZCBhbmQgdGltZW91 dC4uLi4gRG8geW91IHdhbnQgdG8gZml4IHRoZSBzb3VyY2UgY29kZSB0bw0KPj4gPiBtYXRjaCB3 aXRoIHRoZSBkb2N1bWVudD8gT3IgY2hhbmdlIChqdXN0IHJlbW92ZSAiImNvbnRpbnVlcyB1c2lu ZyB0aGUNCj4+ID4gYnVpbHQtaW4gbWV0aG9kIikgdGhlIGRvY3VtZW50PyBJIGFtIGZpbmUgd2l0 aCBjaGFuZ2luZyB0aGUgZG9jdW1lbnQuDQo+PiA+DQo+PiA+IEJlc3QgcmVnYXJkcywNCj4+ID4g LS0NCj4+ID4gVGF0c3VvIElzaGlpDQo+PiA+IFNSQSBPU1MgSy5LLg0KPj4gPiBFbmdsaXNoOiBo dHRwOi8vd3d3LnNyYW9zcy5jby5qcC9pbmRleF9lbi8NCj4+ID4gSmFwYW5lc2U6aHR0cDovL3d3 dy5zcmFvc3MuY28uanANCj4+DQo=