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 1wTYQm-000bYp-1B for pgpool-hackers@arkaria.postgresql.org; Sun, 31 May 2026 05:09:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wTYQk-006uwA-03 for pgpool-hackers@arkaria.postgresql.org; Sun, 31 May 2026 05:09:46 +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 1wTYQj-006uw2-1t for pgpool-hackers@lists.postgresql.org; Sun, 31 May 2026 05:09:46 +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.98.2) (envelope-from ) id 1wTYQh-00000000Pzl-1JeK for pgpool-hackers@lists.postgresql.org; Sun, 31 May 2026 05:09:45 +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=+HEC68gwjqOJY0lcc0GQh2cldnfYxOndw+hmTPqQeJw=; b=gI79LWxxPHaHjMmmSltjBJINUr /uppvibRA1sc6n1fgBmeP/Dp8rV+vOBgapk1t5l4vfMMUNbhPFq8nijA6jvp/dybJVzKI8oZh1xuf 59+l861pf9dZBQrhTPA0sl7YoA6Hxcv8pG/VjfYi0RKNrtHocsYr00m5K8XEs72nNyB0Mqrv+zGQl p5s55b9o1R5yCYJAEkIwYfEWoBjiGc4RSCzW3y514KtPl+CBdLHQDvc2wI5AQZxe6JSS7xv4lt6tz psGw/ULi/ZGqWNgMrZ5xPAlkuDLQSNN60Fb7HdCG0tlpzUCbfDhA7BTrIl6obUiG80XtXBhwP4rph fNli5c7g==; Received: from [2409:11:4120:300:a3e:8d36:42c6:f746] (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 1wTYQd-001AIp-0T; Sun, 31 May 2026 05:09:41 +0000 Date: Sun, 31 May 2026 14:09:28 +0900 (JST) Message-Id: <20260531.140928.1159580709730343176.ishii@postgresql.org> To: nadav@tailorbrands.com Cc: pgpool-hackers@lists.postgresql.org Subject: Re: Proposal: Recent mutated table tracking in memory From: Tatsuo Ishii In-Reply-To: References: <20260521.185044.504532841722447976.ishii@postgresql.org> <20260523.201816.2108820434774242495.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:a3e:8d36:42c6:f746 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgTmFkYXYsDQoNClRoYW5rIHlvdSBmb3IgdjUgcGF0Y2hlcy4gSSBhcHBsaWVkIGJvdGggb2Yg dGhlbSB0byB0b2RheSdzIG1hc3RlciBhbmQNCmFsbCByZWdyZXNzaW9uIHRlc3RzIGFuZCBtb2Rp ZmllZCAwMDYgcGFzc2VkLiBDb25ndXJhdHVsYXRpb25zIQ0KDQpJIHdpbGwgY29udGludWUgdG8g cmV2aWV3IHlvdXIgcGF0Y2hlcy4NCg0KUmVnYXJkcywNCi0tDQpUYXRzdW8gSXNoaWkNClNSQSBP U1MgSy5LLg0KRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAvaW5kZXhfZW4vDQpKYXBh bmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0KDQo+IEhpIFRhdHN1bywNCj4gDQo+IFlvdXIg cmVhbGx5X3dyaXRpbmdfdHJhbnNhY3Rpb24gYXBwcm9hY2ggaXMgdGhlIHJpZ2h0IGZpeCAtLSBp dA0KPiBhZGRyZXNzZXMgdGhlIHJvb3QgY2F1c2UgYWNyb3NzIGFsbCBETEJPVyBtb2Rlcywgbm90 IGp1c3Qgb3Vycy4NCj4gVGhhbmtzIGZvciBkaWdnaW5nIGludG8gaXQuDQo+IA0KPiBJIGFwcGxp ZWQgeW91ciB2MSBwYXRjaCBhbmQgcmViYXNlZCBvdXIgZmVhdHVyZSBvbiB0b3AuICBBdHRhY2hp bmcNCj4gYm90aCBwYXRjaGVzIHNlcGFyYXRlbHkgc28gdGhleSBjYW4gbGFuZCBpbmRlcGVuZGVu dGx5IGluIHRoZQ0KPiBvcmRlciB5b3UgcHJlZmVyOg0KPiANCj4gICB2NS0wMDAxLUZpeC1kaXNh YmxlX2xvYWRfYmFsYW5jZV9vbl93cml0ZS1hbmQtcXVlcnktY2FjaGUucGF0Y2gNCj4gICAgIC0t IHlvdXIgcGF0Y2ggdW5jaGFuZ2VkIChqdXN0IHJlYmFzZWQgdG8gYXBwbHkgY2xlYW5seSBvbg0K PiAgICAgICAgY3VycmVudCBtYXN0ZXIgd2l0aG91dCBvdXIgZmVhdHVyZSB1bmRlcm5lYXRoKS4N Cj4gDQo+ICAgdjUtMDAwMi1GZWF0dXJlLWxvYWQtYmFsYW5jaW5nLWNvbnRyb2wtYnktdGFibGUt dHJhY2tpbmcucGF0Y2gNCj4gICAgIC0tIG91ciBmZWF0dXJlLCBvbiB0b3Agb2YgeW91ciBmaXgu DQo+IA0KPiBDaGFuZ2VzIGluIHY1LTAwMDIgdnMgdjQ6DQo+IA0KPiAtIERyb3BwZWQgcG9vbF9o YXNfZG1sX2FkYXB0aXZlX3dyaXRlX2luX3RyYW5zYWN0aW9uKCkgaGVscGVyIGFuZA0KPiAgIHRo ZSBtYXRjaGluZyBwb29sX2hhc19kbWxfdGFibGVfb2lkcygpIGV4cG9zdXJlLiAgVGhlIGNhY2hl DQo+ICAgZmV0Y2ggZ3VhcmRzIGluIHBvb2xfcHJvdG9fbW9kdWxlcy5jIG5vdyBjb3JyZWN0bHkg dXNlDQo+ICAgcG9vbF9pc19yZWFsbHlfd3JpdGluZ190cmFuc2FjdGlvbigpIGZyb20geW91ciBw YXRjaCwgc28gdGhlDQo+ICAgaGVscGVyIGJlY2FtZSByZWR1bmRhbnQuDQo+IA0KPiAtIEtlcHQg dGhlIE1BSU5fUkVQTElDQSBnYXRlIGluIENvbW1hbmRDb21wbGV0ZS5jIGZvciB0aGUNCj4gICBh dXRvY29tbWl0IG1hcmstc3RhbGUgYnJhbmNoLiAgZG1sX2FkYXB0aXZlX2dsb2JhbCBpcyBvbmx5 DQo+ICAgbWVhbmluZ2Z1bCBpbiBzdHJlYW1pbmcgcmVwbGljYXRpb24gbW9kZSAobWF0Y2hlcyB0 aGUgcm91dGluZw0KPiAgIGxvZ2ljIGluIHdoZXJlX3RvX3NlbmRfbWFpbl9yZXBsaWNhKSwgYW5k IGdhdGluZyBwcmV2ZW50cyB0aGUNCj4gICBoYW5nIHdlIHNhdyBpbiBuYXRpdmVfcmVwbGljYXRp b24gd2hlcmUgdGhlIGF1dG9jb21taXQgYnJhbmNoDQo+ICAgY291bGQgcnVuIHdoaWxlIGFuIGV4 cGxpY2l0IHRyYW5zYWN0aW9uIHdhcyBhY3R1YWxseSBpbiBmbGlnaHQNCj4gICBvbiB0aGUgYmFj a2VuZC4NCj4gDQo+IEkgdHJpZWQgdG8gcnVuIDAwNi5tZW1xY2FjaGUgd2l0aCB0aGUgbXV0YXRp b24gYWdhaW5zdCB0aGUNCj4gY29tYmluZWQgYnJhbmNoIGJ1dCBsb2NhbCBtYXN0ZXIgaXMgY3Vy cmVudGx5IGJyb2tlbiAoY29tbWl0DQo+IDJhZTAwNGE0OCBhcyB5b3Ugbm90ZWQpLCBzbyB0aGUg c3RhbmRieSBzZXR1cCBmYWlscyBiZWZvcmUNCj4gcmVhY2hpbmcgdGhlIGpkYmN0ZXN0IHBhcnQu ICBCb3RoIHBhdGNoZXMgYnVpbGQgY2xlYW5seSBhbmQgb3VyDQo+IDA0My50cmFja190YWJsZV9t dXRhdGlvbiBwYXNzZXMgb24gYW4gZWFybGllciBiYXNlLiAgV2lsbCByZXRlc3QNCj4gb25jZSBt YXN0ZXIgaXMgdW5icm9rZW4uDQo+IA0KPiBUaGFua3MhDQo+IA0KPiBPbiBTYXQsIE1heSAyMywg MjAyNiBhdCAyOjE44oCvUE0gVGF0c3VvIElzaGlpIDxpc2hpaUBwb3N0Z3Jlc3FsLm9yZz4gd3Jv dGU6DQo+IA0KPj4gPiBJIHRoaW5rIHlvdSBhcmUgdGFsa2luZyBhYm91dCB0aGUgbG9naWMgdG8g anVkZ2Ugd2hldGhlciB3ZSBhcmUgaW4gYW4NCj4+ID4gZXhwbGljaXRlIHRyYW5zYWN0aW9uIG9y IG5vdCBoZXJlLiBDdXJyZW50IGRtbF9hZGFwdGl2ZSBjaGVja3MNCj4+ID4gc3VwcGxpZWQgcXVl cnkgaXMgYSB0cmFuc2FjdGlvbiBzdGFydGluZyBjb21tYW5kIGxpa2UgQkVHSU4uIElNTyB0aGlz DQo+PiA+IGlzIGZ1bmRhbWVudGFseSB3cm9uZyBiZWNhdXNlIHRoZSBjb21tYW5kIG1heSBmYWls IGJ5IHZhcmlvdXMgcmVhc29ucy4NCj4+ID4gVGhlIGNvcnJlY3Qgd2F5IGlzIGNoZWNraW5nIHRy YW5zYWN0aW9uIHN0YXRlIGJ5IHVzaW5nIFRTVEFURQ0KPj4gPiBtYWNyby4gTm90ZSB0aGF0IHRo ZSBtYWNybyBjYW4gb25seSBiZSB1c2VkIGF0IGxlYXQgb25lIHJlYWR5IGZvcg0KPj4gPiBxdWVy eSByZXNwb25zZSByZXR1cm5lZCBmcm9tIGJhY2tlbmQgKHNpbXBsZSBxdWVyeSBwcm90b2NvbCBj YXNlKSwgb3INCj4+ID4gY29tbWFuZCBjb21wbGV0ZSByZXNwb25zZSBpcyByZXR1cm5lZCBmcm9t IGJhY2tlbmQgKGV4dGVuZGVkIHF1ZXJ5DQo+PiA+IHByb3RvY29sIGNhc2UpLg0KPj4gPg0KPj4g Pj4gSW4gbmF0aXZlIHJlcGxpY2F0aW9uIGFuZCBzbmFwc2hvdCBpc29sYXRpb24gbW9kZXMsDQo+ PiA+PiBkbWxfYWRhcHRpdmUoKSBpcyBuZXZlciBjYWxsZWQgKGl0IGxpdmVzIGluc2lkZQ0KPj4g Pj4gd2hlcmVfdG9fc2VuZF9tYWluX3JlcGxpY2EpLCBzbyBpc19pbl90cmFuc2FjdGlvbiBpcyBu ZXZlciBzZXQNCj4+ID4+IHRvIHRydWUgZXZlbiBpbnNpZGUgYW4gZXhwbGljaXQgQkVHSU4vQ09N TUlUIGJsb2NrLiAgVGhhdCBtZWFudA0KPj4gPj4gZXZlcnkgRE1MIGluIHRob3NlIG1vZGVzIHdh cyB0cmVhdGVkIGFzIGF1dG9jb21taXQgYnkgdGhlDQo+PiA+PiB3cml0ZS10cmFja2luZyBjb2Rl LCB0cmlnZ2VyaW5nDQo+PiA+PiBwb29sX3RyYWNrX3RhYmxlX211dGF0aW9uX2dldF9kYXRhYmFz ZV9vaWQoKSDigJUgd2hpY2ggZG9lcyBhDQo+PiA+PiByZWxjYWNoZSBkb19xdWVyeSDigJUgd2hp bGUgYSB0cmFuc2FjdGlvbiB3YXMgYWN0dWFsbHkgaW4gZmxpZ2h0DQo+PiA+PiBvbiB0aGUgYmFj a2VuZCBjb25uZWN0aW9uLiAgVGhlIGRvX3F1ZXJ5IGNvbmZsaWN0cyB3aXRoIHRoZQ0KPj4gPj4g aW4tZmxpZ2h0IHRyYW5zYWN0aW9uIGFuZCBoYW5ncyB0aGUgc2Vzc2lvbi4NCj4+ID4NCj4+ID4g QXNzdW1pbmcgImEgdHJhbnNhY3Rpb24gd2FzIGFjdHVhbGx5IGluIGZsaWdodCIgbWVhbnMgYSB0 cmFuc2FjdGlvbg0KPj4gPiB3YXMgb3BlbiAoZXhwbGljaXQgdHJhbnNhY3Rpb24pLCBub3QgcmVh bGx5LiBkb19xdWVyeSBjYW4gYmUgY2FsbGVkDQo+PiA+IGluc2lkZSBvciBvdXRzaWRlIG9mIGFu IGV4cGxpY2l0IHRyYW5zYWN0aW9uLg0KPj4gPg0KPj4gPiBBbnl3YXksIEkgZm91bmQgZG1sX2Fk YXB0aXZlIGlzIGNvbXBsZXRlbHkgYnJva2VuIChpdCBicmluZ3Mgd3JvbmcNCj4+ID4gcmVzdWx0 cyBpZiBxdWVyeSBjYWNoZSBlbmFibGVkKS4gVW5sZXNzIHRoZXJlIGFyZSB1c2VycyBmb3IgdGhl DQo+PiA+IGZlYXR1cmUsIG1heWJlIHdlIHNob3VsZCByZW1vdmUgZG1sX2FkYXB0aXZlIGVudGly ZWx5Pw0KPj4NCj4+IEl0IGFwcGVhcnMgdGhhdCBvdGhlciBvcHRpb25zIG9mIGRpc2FibGVfbG9h ZF9iYWxhbmNlX29uX3dyaXRlIGFyZSBhbGwNCj4+IGJyb2tlbiB0b28sIGV4Y2VwdCAidHJhbnNh Y3Rpb24iLiBJIGRvbid0IHdhbnQgdG8gZGlzY2FyZCBhbGwgb2YgdGhlbSwNCj4+IHNvIEkgY29t ZSB1cCB3aXRoIGF0dGFjaGVkIHBhdGNoLg0KPj4NCj4+IFRoZSBxdWVyeSBjYWNoZSByZWxpZXMg b24gaXNfd3JpdGluZ190cmFuc2FjdGlvbiBvZiBzZXNzaW9uIGNvbnRleHQgdG8NCj4+IGp1ZGdl IHdoZXRoZXIgY2FjaGUgY2FuIGJlIHNhZmVseSB1c2VkLiBIb3dldmVyLA0KPj4gZGlzYWJsZV9s b2FkX2JhbGFuY2Vfb25fd3JpdGUgb3ZlcnJpZGVzIGl0IHRvIHRydWUgd2hlbiBpdCBzaG91bGQg bm90LA0KPj4gYW5kIHZpY2UgdmVyc2EgZm9yIGl0cyBvd24gcHVycG9zZS4gVG8gZml4IHRoaXMs IGEgbmV3IHNlc3Npb24gY29udGV4dA0KPj4gdmFyaWFibGUgInJlYWxseV93cml0aW5nX3RyYW5z YWN0aW9uIiBpcyBpbnRyb2R1Y2VkLiBJdCBpcyBhbG1vc3Qgc2FtZQ0KPj4gYXMgZXhpc3Rpbmcg d3JpdGluZ190cmFuc2FjdGlvbiwgYnV0IGl0IGZhaXRoZnVsbHkgdHJhY2tzIHdoZXRoZXIgYQ0K Pj4gd3JpdGluZyBxdWVyeSBhcHBlYXJzIGluIGFuIGV4cGxpY2l0IHRyYW5zYWN0aW9uLiBUaGUg cXVlcnkgY2FjaGUgdXNlcw0KPj4gaXQgaW5zdGVhZCBvZiB3cml0aW5nX3RyYW5zYWN0aW9uIHZh cmlhYmxlLg0KPj4NCj4+IEN1cnJlbnRseSwgbWFzdGVyIGJyYW5jaCBpcyBicm9rZW4gYmVjYXVz ZSBvZiBjb21taXQgMmFlMDA0YTQ4LiAgSWYNCj4+IHlvdSB3YW50IHRvIHRyeSB0aGUgcGF0Y2gs IEkgcmVjb21tZW5kIHRvIGNoZWNrb3V0IDQ4ZTFkNmQzYywgdGhlbg0KPj4gYXBwbHkgdGhlIHBh dGNoLg0KPj4NCj4+IFJlZ2FyZHMsDQo+PiAtLQ0KPj4gVGF0c3VvIElzaGlpDQo+PiBTUkEgT1NT IEsuSy4NCj4+IEVuZ2xpc2g6IGh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwL2luZGV4X2VuLw0KPj4g SmFwYW5lc2U6aHR0cDovL3d3dy5zcmFvc3MuY28uanANCj4+DQo+IA0KPiANCj4gLS0gDQo+IE5h ZGF2IFNoYXR6DQo+IFRhaWxvciBCcmFuZHMgfCBDVE8NCg==