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 1vdipZ-003unU-20 for pgpool-hackers@arkaria.postgresql.org; Thu, 08 Jan 2026 05:45:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vdipX-000Pp3-2F for pgpool-hackers@arkaria.postgresql.org; Thu, 08 Jan 2026 05:45:08 +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 1vdipX-000Pow-11 for pgpool-hackers@lists.postgresql.org; Thu, 08 Jan 2026 05:45:08 +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 1vdipV-005DhC-1J for pgpool-hackers@lists.postgresql.org; Thu, 08 Jan 2026 05:45:07 +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=TkJuqNZfbmfn3GYIRk/Rt1Bnoaakvq2vELtIamKoajE=; b=tdUkFxJQwlYEOmKLoa1Mb7oI6Z Jb/3zrT7PA0HTftmKoMlHrKv0SPh5v+dbWu6l5t5ggHxU0hoyLjj180zcNI/S5rS/oM9EMie0c4Cd NL9OatOuk4Ff07bFALE3D+VrUqPFWff7tnKbQo4mgFV6mwq2SG1PA8x24BbXBRASctInJHmWhphaw yEZD8t4JuNA2r5r77oS4wdT9Ct3gJO9h47oY/dOQQfoITzgBFeAfuSWXeCM8HG64ylN7je3GBqT6M oiCFZcUegQ7Ppmvvq325oeAYjDrpoTqVzbaBt4i2Mvuiahm/rKp8oObdweR6B45YtV+5GPFAi02FD wvnePYYQ==; Received: from [2409:11:4120:300:f2b0:e99a:ab8b:6105] (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 1vdipR-00AXU6-1C; Thu, 08 Jan 2026 05:45:03 +0000 Date: Thu, 08 Jan 2026 14:44:52 +0900 (JST) Message-Id: <20260108.144452.1551324238617142515.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.154320.1734616587238293334.ishii@postgresql.org> <20260108.111911.1930855426356010993.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:f2b0:e99a:ab8b:6105 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhhbiB5b3UgZm9yIHRoZSByZXZpZXchDQpJIHdpbGwgY29tbWl0IHRoZSBwYXRjaC4NCg0KQmVz dCByZWdhcmRzLA0KLS0NClRhdHN1byBJc2hpaQ0KU1JBIE9TUyBLLksuDQpFbmdsaXNoOiBodHRw Oi8vd3d3LnNyYW9zcy5jby5qcC9pbmRleF9lbi8NCkphcGFuZXNlOmh0dHA6Ly93d3cuc3Jhb3Nz LmNvLmpwDQoNCj4gTXVjaCBtdWNoIGJldHRlciBhbmQgY2xlYW5lciEgVGhhbmtzIQ0KPiANCj4g TmFkYXYgU2hhdHoNCj4gVGFpbG9yIEJyYW5kcyB8IENUTw0KPiANCj4gDQo+IE9uIFRodSwgSmFu IDgsIDIwMjYgYXQgNDoxOeKAr0FNIFRhdHN1byBJc2hpaSA8aXNoaWlAcG9zdGdyZXNxbC5vcmc+ IHdyb3RlOg0KPiANCj4+IEhpIE5hZGF2LA0KPj4NCj4+IEkgaGF2ZSBqdXN0IG5vdGljZWQgdGhh dCBjaGVja19yZXBsaWNhdGlvbl90aW1lX2xhZ193aXRoX2NtZCgpIGNhbiBiZQ0KPj4gc2ltcGxp ZmllZCBieSB1c2luZyBTdHJpbmdJbmZvIGZ1bmN0aW9ucy4gUGF0Y2ggYXR0YWNoZWQuIFdoYXQg ZG8geW91DQo+PiB0aGluaz8NCj4+DQo+PiBCZXN0IHJlZ2FyZHMsDQo+PiAtLQ0KPj4gVGF0c3Vv IElzaGlpDQo+PiBTUkEgT1NTIEsuSy4NCj4+IEVuZ2xpc2g6IGh0dHA6Ly93d3cuc3Jhb3NzLmNv LmpwL2luZGV4X2VuLw0KPj4gSmFwYW5lc2U6aHR0cDovL3d3dy5zcmFvc3MuY28uanANCj4+DQo=