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 1vF5E3-007DqD-H1 for pgpool-hackers@arkaria.postgresql.org; Sat, 01 Nov 2025 06:36:35 +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 1vF5E0-003jG0-3B for pgpool-hackers@arkaria.postgresql.org; Sat, 01 Nov 2025 06:36:31 +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 1vF5Dz-003jFs-OU for pgpool-hackers@lists.postgresql.org; Sat, 01 Nov 2025 06:36:30 +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 1vF5Dv-004rFQ-0p for pgpool-hackers@lists.postgresql.org; Sat, 01 Nov 2025 06:36:29 +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=jwt6seM2+LnOEESFbjB/kEpODT1N831eKVoQ5DbcXlw=; b=UhG2zHpC2spb4koDE1WyTttAPf ZA04RcIsxx/8X0jSz9xFWW0vw4ZjATyO4QhwBApNKI/thZkYh5ELm1sDyCo24hoUKbwLYTkcHqaUo 5Nc/62YKxoj7HXHRbMoJIXBPHGhPM5ShKFRHtr62y0xlbSrlbHmBOdBR5r0rP2DRvcSmcCMIoCVsm HpHKkZpa9EHEC5g20M1km0Whf8O0fNc/Ho8GclAm5oX+wIrKUHViebu3f206edptDfa21QB8z4U43 gir3b3X4WjLYyulEqOT1YvkFHckKm6N3EuOurm8xycT4nHGDA4MjD8AwAj5xW2uzJHo8HvPR5Teou 9cuPxfbw==; Received: from [2409:11:4120:300:3c8c:2a98:dc39:dd71] (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 1vF5Ds-00CnY7-05; Sat, 01 Nov 2025 06:36:26 +0000 Date: Sat, 01 Nov 2025 15:36:14 +0900 (JST) Message-Id: <20251101.153614.73929001756644634.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: <20251031.084526.310963640592087194.ishii@postgresql.org> References: <20250930.183509.1786375391511683043.ishii@postgresql.org> <20251031.084526.310963640592087194.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 29.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=iso-8859-7 Content-Transfer-Encoding: base64 X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:3c8c:2a98:dc39:dd71 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Pj4gSGksDQo+PiANCj4+IEknbSBiYWNrIGF0IHdvcmsgLSB3ZHl0IG9mIHRoaXMgdmVyc2lvbj8N Cj4gDQo+IFRoYW5rcyBmb3IgdGhlIHBhdGNoISBJIHdpbGwgbG9vayBpbnRvIGl0IHdlZWtlbmQu DQoNCkhlcmUgYXJlIHJldmlldyBjb21tZW50cy4NCg0KMS4gZ2l0IGFwcGx5IGNvbXBsYWlucyB0 cmFpbGluZyB3aGl0ZXNwYWNlIGFuZCBuZXcgYmxhbmsgbGluZS4NCg0KJCBnaXQgYXBwbHkgfi8w MDAxLWV4dGVybmFsLXJlcGxpY2F0aW9uLWRlbGF5LWltcGxlbWVudGF0aW9uLnBhdGNoIA0KL2hv bWUvdC1pc2hpaS8wMDAxLWV4dGVybmFsLXJlcGxpY2F0aW9uLWRlbGF5LWltcGxlbWVudGF0aW9u LnBhdGNoOjIyNTogdHJhaWxpbmcgd2hpdGVzcGFjZS4NCgkJDQovaG9tZS90LWlzaGlpLzAwMDEt ZXh0ZXJuYWwtcmVwbGljYXRpb24tZGVsYXktaW1wbGVtZW50YXRpb24ucGF0Y2g6MjMyOiB0cmFp bGluZyB3aGl0ZXNwYWNlLg0KCQkJDQovaG9tZS90LWlzaGlpLzAwMDEtZXh0ZXJuYWwtcmVwbGlj YXRpb24tZGVsYXktaW1wbGVtZW50YXRpb24ucGF0Y2g6MjQ2OiB0cmFpbGluZyB3aGl0ZXNwYWNl Lg0KCQkJDQp3YXJuaW5nOiAzIGxpbmVzIGFkZCB3aGl0ZXNwYWNlIGVycm9ycy4NCiQgZ2l0IGFw cGx5IH4vMDAwMi1leHRlcm5hbC1yZXBsaWNhdGlvbi1kZWxheS10ZXN0cy1hbmQtZG9jcy5wYXRj aCANCi9ob21lL3QtaXNoaWkvMDAwMi1leHRlcm5hbC1yZXBsaWNhdGlvbi1kZWxheS10ZXN0cy1h bmQtZG9jcy5wYXRjaDo2Mzk6IG5ldyBibGFuayBsaW5lIGF0IEVPRi4NCisNCndhcm5pbmc6IDEg bGluZSBhZGRzIHdoaXRlc3BhY2UgZXJyb3JzLg0KDQoyLiBZb3UgY2FuIHVzZSBwc3ByaW50Zigp IGluc3RlYWQgb2YgcGFsbG9jKCkgKyBzbnByaW50ZigpIHRvIG1ha2UgdGhlIGNvZGUgc2ltcGxl ci4NCg0KKwlpZiAoIWJpIHx8IGJpLT5iYWNrZW5kX2hvc3RuYW1lWzBdID09ICdcMCcgfHwgYmkt PmJhY2tlbmRfcG9ydCA8PSAwKQ0KKwl7DQorCQkvKiBGYWxsYmFjayBpZiBob3N0bmFtZSBvciBw b3J0IGlzIG5vdCBzZXQgKi8NCisJCW91dCA9IHBhbGxvYygzMik7DQorCQlzbnByaW50ZihvdXQs IDMyLCAidW5rbm93bl9ub2RlXyVkIiwgbm9kZV9pZCk7DQorCQlyZXR1cm4gb3V0Ow0KKwl9DQoN CjMuIERpdHRvIGFzIGFib3ZlLg0KDQorCS8qIFVzZSBob3N0bmFtZTpwb3J0IGZvcm1hdCAqLw0K KwlobGVuID0gc3RybGVuKGJpLT5iYWNrZW5kX2hvc3RuYW1lKTsNCisJLyogbWF4IHBvcnQgY2hh cnMgfjUsIHBsdXMgY29sb24gYW5kIE5VTCAqLw0KKwlvdXRfbGVuID0gaGxlbiArIDEgKyA1ICsg MTsNCisJb3V0ID0gcGFsbG9jKG91dF9sZW4pOw0KKwlzbnByaW50ZihvdXQsIG91dF9sZW4sICIl czolZCIsIGJpLT5iYWNrZW5kX2hvc3RuYW1lLCBiaS0+YmFja2VuZF9wb3J0KTsNCisJcmV0dXJu IG91dDsNCg0KNC4gVGhlcmUgYXJlIGEgZmV3IGNvbXBpbGVyIHdhcm5pbmdzLg0KDQpzdHJlYW1p bmdfcmVwbGljYXRpb24vcG9vbF93b3JrZXJfY2hpbGQuYzogSW4gZnVuY3Rpb24goWRvX3dvcmtl cl9jaGlsZKI6DQpzdHJlYW1pbmdfcmVwbGljYXRpb24vcG9vbF93b3JrZXJfY2hpbGQuYzoyNjk6 MzM6IHdhcm5pbmc6IHRoaXMgoWVsc2WiIGNsYXVzZSBkb2VzIG5vdCBndWFyZC4uLiBbLVdtaXNs ZWFkaW5nLWluZGVudGF0aW9uXQ0KICAyNjkgfCAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIGVsc2UNCiAgICAgIHwgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBefn5+DQpz dHJlYW1pbmdfcmVwbGljYXRpb24vcG9vbF93b3JrZXJfY2hpbGQuYzoyNzM6NDE6IG5vdGU6IC4u LnRoaXMgc3RhdGVtZW50LCBidXQgdGhlIGxhdHRlciBpcyBtaXNsZWFkaW5nbHkgaW5kZW50ZWQg YXMgaWYgaXQgd2VyZSBndWFyZGVkIGJ5IHRoZSChZWxzZaINCiAgMjczIHwgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIG5vZGVfc3RhdHVzID0gdmVyaWZ5X2JhY2tlbmRf bm9kZV9zdGF0dXMoc2xvdHMpOw0KICAgICAgfCAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgXn5+fn5+fn5+fn4NCg0KNS4gMDQxLmV4dGVybmFsX3JlcGxpY2F0aW9uX2Rl bGF5IGZhaWxlZC4NCg0KdGltZW91dDogZmFpbGVkIHRvIHJ1biBjb21tYW5kICcuL3Rlc3Quc2gn OiBQZXJtaXNzaW9uIGRlbmllZA0KDQpBZnRlciBydW5uaW5nICJjaG1vZCA3NTUiIHRvIGZpeCB0 aGUgaXNzdWUsIHN0aWxsIHRoZSB0ZXN0IGZhaWxzLiBGcm9tDQpzcmMvdGVzdC9yZWdyZXNzaW9u L2xvZy8wNDEuZXh0ZXJuYWxfcmVwbGljYXRpb25fZGVsYXk6DQoNCi4vdGVzdC5zaDogbGluZSA0 NTogc3ludGF4IGVycm9yIG5lYXIgdW5leHBlY3RlZCB0b2tlbiBgKCcNCi4vdGVzdC5zaDogbGlu ZSA0NTogYGVjaG8gPT09IFRlc3QwOiBFeHRlcm5hbCBjb21tYW5kIHJlY2VpdmVzIHJlcGxpY2Eg aWRlbnRpZmllcnMgb25seSAocHJpbWFyeSBvbWl0dGVkKSA9PT0nDQoNCkJlc3QgcmVnYXJkcywN Ci0tDQpUYXRzdW8gSXNoaWkNClNSQSBPU1MgSy5LLg0KRW5nbGlzaDogaHR0cDovL3d3dy5zcmFv c3MuY28uanAvaW5kZXhfZW4vDQpKYXBhbmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0K