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 1wbzT3-0030Bz-1B for pgpool-hackers@arkaria.postgresql.org; Tue, 23 Jun 2026 11:39:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wbzT2-00BQlT-19 for pgpool-hackers@arkaria.postgresql.org; Tue, 23 Jun 2026 11:39:00 +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 1wbzT2-00BQlM-0U for pgpool-hackers@lists.postgresql.org; Tue, 23 Jun 2026 11:39:00 +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 1wbzSz-00000001ucX-2wW4 for pgpool-hackers@lists.postgresql.org; Tue, 23 Jun 2026 11:38:59 +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=QaNTzem5ecLF3Vll8AQfAtEmoXL5UQpANGOdz57F3iI=; b=fEAccLgVv5JurAnaBia9i6/YWb UhokfjKVKix5+9+tbG5ZCFws+lcVCTXdt7KjvnEqTy23NnIdttG5jTJ1O4DJFQt6X8A/FTrDwvoPA K2iwxaKytmmnOuui2jK2+5a1Wj5BSsiKcw8fUIam2y+XyMhrKJ11SD08V6wrhU/kze2ubpOFujk+B YYxHNt3/ynrS+jK1bTirrklBO3C0Fhg7IdMaJ9bvq2UqiqoFBYgwvcZ4Dy8XW2FwEQK+wsgHZ4Qb3 Ybl4/gCAfmRUPmwSkhM+S5jBeKhFaq32ayCKgBimfz6uMIu2y92JEhqNzNhjinl2tuMSN+DX8Mf1V XlTFta4Q==; Received: from [2409:11:4120:300:d75a:66c6:95a6:4204] (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 1wbzSv-0053ae-1v; Tue, 23 Jun 2026 11:38:55 +0000 Date: Tue, 23 Jun 2026 20:38:48 +0900 (JST) Message-Id: <20260623.203848.466544893109845043.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: <20260619.111037.159094338431818955.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:d75a:66c6:95a6:4204 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgTmFkYXYsDQoNClRoYW5rIHlvdSBmb3IgdXBkYXRpbmcgdGhlIHBhdGNoLiBJIHdpbGwgbG9v ayBpbnRvIHRoaXMuDQoNClJlZ2FyZHMsDQotLQ0KVGF0c3VvIElzaGlpDQpTUkEgT1NTIEsuSy4N CkVuZ2xpc2g6IGh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwL2luZGV4X2VuLw0KSmFwYW5lc2U6aHR0 cDovL3d3dy5zcmFvc3MuY28uanANCg0KPiBIaSBUYXRzdW8sDQo+IA0KPiBHb29kIGNhdGNoIC0t IHRoYXQgd2FzIGEgYnVnLCBhbmQgY2hhc2luZyBpdCBkb3duIHR1cm5lZCB1cCBhIHNlY29uZA0K PiBvbmUgaW4gdGhlIHNhbWUgYXJlYS4NCj4gDQo+IFRoZSBvcmlnaW5hbCBwcm9ibGVtIHlvdSBk ZXNjcmliZWQ6IHRoZSBmbHVzaCByYW4gaW4gZG1sX2FkYXB0aXZlKCkNCj4gd2hpbGUgcGdwb29s IHdhcyAqcm91dGluZyogdGhlIENPTU1JVCwgYmVmb3JlIHRoZSBDT01NSVQgd2FzIHNlbnQgdG8N Cj4gdGhlIGJhY2tlbmQuICBTbyBhIENPTU1JVCB0aGF0IGxhdGVyIGZhaWxlZCAoeW91ciBkZWZl cnJlZC1jb25zdHJhaW50DQo+IGV4YW1wbGUpIGhhZCBhbHJlYWR5IG1hcmtlZCB0aGUgdGFibGVz LCBldmVuIHRob3VnaCB0aGUgd3JpdGVzIHJvbGxlZA0KPiBiYWNrLg0KPiANCj4gTXkgZmlyc3Qg aW5zdGluY3Qgd2FzIHRvIGp1c3QgbW92ZSB0aGUgZmx1c2ggdG8gaGFuZGxlX3F1ZXJ5X2NvbnRl eHQoKSwNCj4gd2hlcmUgcmVhY2hpbmcgQ29tbWFuZENvbXBsZXRlIGZvciB0aGUgQ09NTUlUIG1l YW5zIGl0IHN1Y2NlZWRlZC4gIEJ1dA0KPiB0aGF0IHBhdGggcmVzb2x2ZXMgdGFibGUvZGF0YWJh c2UgT0lEcyB2aWEgcG9vbF90YWJsZV9uYW1lX3RvX29pZCgpIC8NCj4gdGhlIHJlbGNhY2hlLCB3 aGljaCBvbiBhIGNhY2hlIG1pc3MgaXNzdWVzIGEgZG9fcXVlcnkoKSAtLSBhbmQgYXQgdGhhdA0K PiBwb2ludCB0aGUgQ09NTUlUIHJlc3BvbnNlIGlzIHN0aWxsIGJlaW5nIHJlYWQgZnJvbSB0aGUg YmFja2VuZCwgc28NCj4gaW5qZWN0aW5nIGEgcXVlcnkgZGVzeW5jcyB0aGUgcHJvdG9jb2wgYW5k IGhhbmdzIHRoZSBzZXNzaW9uLiAgVGVzdGluZw0KPiBjYXVnaHQgdGhpcyBpbW1lZGlhdGVseS4N Cj4gDQo+IEl0IHR1cm5lZCBvdXQgdGhlIGV4aXN0aW5nIGF1dG9jb21taXQgbWFya2luZyBicmFu Y2ggaGFkIHRoZSB2ZXJ5IHNhbWUNCj4gaGF6YXJkOiBwb29sX2V4dHJhY3RfdGFibGVfb2lkcygp IGluIGhhbmRsZV9xdWVyeV9jb250ZXh0KCkgYWxzbyBkb2VzIGENCj4gcmVsY2FjaGUgZG9fcXVl cnkoKSBvbiBhIG1pc3MsIHNvIGUuZy4gIkRST1AgVEFCTEUgSUYgRVhJU1RTIDxub25leGlzdGVu dD4iDQo+IChhbiB1bmNhY2hlYWJsZSBuYW1lIC0+IGd1YXJhbnRlZWQgbWlzcykgcmVsaWFibHkg aHVuZyB0aGUgc2Vzc2lvbiB0b28uDQo+IA0KPiBTbyBJIGZpeGVkIGJvdGggdW5pZm9ybWx5OiBy ZXNvbHZlIHRoZSB3cml0dGVuIHRhYmxlcycgT0lEcyAoYW5kIHRoZQ0KPiBkYXRhYmFzZSBPSUQp IGF0IERNTCAqcm91dGluZyogdGltZSwgd2hlbiB0aGUgY29ubmVjdGlvbiBpcyBpZGxlIGFuZA0K PiBkb19xdWVyeSBpcyBzYWZlIC0tIHRoZSBzYW1lIGNvbnRleHQgd2hlcmUgdGhlIGZlYXR1cmUg YWxyZWFkeSByZXNvbHZlcw0KPiBPSURzIGZvciB0aGUgU0VMRUNUIHN0YWxlbmVzcyBjaGVjay4g IFRoZSBPSURzIGFyZSBzdGFzaGVkIGluIHRoZQ0KPiBzZXNzaW9uIGNvbnRleHQgYW5kIG9ubHkg Km1hcmtlZCogaW4gc2hhcmVkIG1lbW9yeSBhdCBDb21tYW5kQ29tcGxldGUsDQo+IHdoaWNoIG5v dyBkb2VzIG5vIGJhY2tlbmQgSS9PIGF0IGFsbC4gIEF1dG9jb21taXQgc3RhdGVtZW50cyBtYXJr IG9uDQo+IHRoZWlyIG93biBDb21tYW5kQ29tcGxldGU7IGV4cGxpY2l0IHRyYW5zYWN0aW9ucyBh Y2N1bXVsYXRlIGFuZCBtYXJrIG9uDQo+IENPTU1JVDsgUk9MTEJBQ0sgYW5kIGZhaWxlZC9yb2xs ZWQtYmFjayBDT01NSVRzIG5ldmVyIHJlYWNoIHRoZSBtYXJrDQo+IHN0ZXAsIHNvIHRoZWlyIHdy aXRlcyBhcmUgY29ycmVjdGx5IG5vdCByZWNvcmRlZC4NCj4gDQo+IEEgc2lkZSBiZW5lZml0OiB1 c2luZyBwb29sX2V4dHJhY3RfdGFibGVfb2lkcygpIGZvciBib3RoIHBhdGhzIG1lYW5zIHdlDQo+ IG5vdyBtYXJrIG9ubHkgdGhlIGFjdHVhbCB3cml0ZSAqdGFyZ2V0cyosIGluc3RlYWQgb2YgZXZl cnkgcmVsYXRpb24gaW4NCj4gdGhlIHN0YXRlbWVudCAodGhlIGluLXRyYW5zYWN0aW9uIHBhdGgg cHJldmlvdXNseSB3YWxrZWQgYWxsIFJhbmdlVmFycywNCj4gc28gYW4gIklOU0VSVCAuLi4gU0VM RUNUIEZST00gdCIgd291bGQgYWxzbyBtYXJrIHRoZSByZWFkIHNvdXJjZSB0KS4NCj4gDQo+IFNp bmNlIHlvdXIgcmVhbGx5X3dyaXRpbmdfdHJhbnNhY3Rpb24gZml4IGlzIG5vdyBpbiBtYXN0ZXIg KDEzMzNkMmFlOCksDQo+IEkgZHJvcHBlZCB0aGUgY29weSBJIHdhcyBjYXJyeWluZyBhbmQgcmVi YXNlZCB0aGUgZmVhdHVyZSBkaXJlY3RseSBvbnRvDQo+IGN1cnJlbnQgbWFzdGVyLiAgT25lIHBh dGNoIHRoaXMgdGltZToNCj4gDQo+ICAgdjYtMDAwMS1GZWF0dXJlLWxvYWQtYmFsYW5jaW5nLWNv bnRyb2wtYnktdGFibGUtdHJhY2tpbmcucGF0Y2gNCj4gDQo+IFZlcmlmaWVkIG9uIGEgUEcxNiBz dHJlYW1pbmctcmVwbGljYXRpb24gY2x1c3RlciAoZG1sX2FkYXB0aXZlX2dsb2JhbCwNCj4gc3Rh bmRieSB3ZWlnaHRlZCBmb3IgbG9hZCBiYWxhbmNpbmcpOg0KPiANCj4gICAtIHlvdXIgZGVmZXJy ZWQtY29uc3RyYWludCBDT01NSVQgZmFpbHMgLT4gdGFibGUgbm90IG1hcmtlZCAtPiByZWFkcw0K PiAgICAga2VlcCBsb2FkLWJhbGFuY2luZyB0byB0aGUgc3RhbmRieTsNCj4gICAtIGEgc3VjY2Vz c2Z1bCBDT01NSVQsIGFuZCBhIHN1Y2Nlc3NmdWwgYXV0b2NvbW1pdCB3cml0ZSAtPiB0YWJsZQ0K PiAgICAgbWFya2VkIC0+IHJlYWRzIGZvcmNlZCB0byB0aGUgcHJpbWFyeTsNCj4gICAtIENPTU1J VCByZXR1cm5zIHByb21wdGx5IChubyBoYW5nKSwgYW5kICJEUk9QIFRBQkxFIElGIEVYSVNUUw0K PiAgICAgPG5vbmV4aXN0ZW50PiIgbm8gbG9uZ2VyIGhhbmdzLg0KPiANCj4gVGhhbmtzIQ0KPiAN Cj4gT24gRnJpLCBKdW4gMTksIDIwMjYgYXQgNToxMOKAr0FNIFRhdHN1byBJc2hpaSA8aXNoaWlA cG9zdGdyZXNxbC5vcmc+IHdyb3RlOg0KPiANCj4+ID4gdW5kZXJzdG9vZC4gd2UnbGwgd2FpdCBw YXRpZW50bHkgb3IgdHJ5IG1hc3Rlci4NCj4+ID4NCj4+ID4gdGhhbmtzIQ0KPj4NCj4+IFdoaWxl IHJldmlld2luZw0KPj4gdjUtMDAwMi1GZWF0dXJlLWxvYWQtYmFsYW5jaW5nLWNvbnRyb2wtYnkt dGFibGUtdHJhY2tpbmcucGF0Y2gsIEkNCj4+IG5vdGljZWQgZm9sbG93aW5nIGNvZGU6DQo+Pg0K Pj4gIHN0YXRpYyB2b2lkDQo+PiAgZG1sX2FkYXB0aXZlKE5vZGUgKm5vZGUsIGNoYXIgKnF1ZXJ5 KQ0KPj4gIHsNCj4+IDoNCj4+IDoNCj4+ICsgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg LyoNCj4+ICsgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICogRm9yIGRtbF9hZGFwdGl2 ZV9nbG9iYWw6IG9uIENPTU1JVCwNCj4+IGZsdXNoIHRoZSBhY2N1bXVsYXRlZA0KPj4gKyAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgKiB0YWJsZSB3cml0ZXMgdG8gc2hhcmVkIG1lbW9y eS4gIE9uDQo+PiBST0xMQkFDSywgc2tpcCAtLSB0aGUNCj4+ICsgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICogd3JpdGVzIG5ldmVyIGNvbW1pdHRlZCBzbyBubyBzdGFsZS1yZWFkDQo+ PiByaXNrIGV4aXN0cy4gIFRoaXMNCj4+ICsgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICogcHJldmVudHMgcG9sbHV0aW5nIHRoZSB0YWJsZSBtYXAgd2l0aA0KPj4gcm9sbGVkLWJhY2sN Cj4+ICsgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICogdHJhbnNhY3Rpb25zLg0KPj4g KyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgKi8NCj4+ICsgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgaW50ICAgICAgICAgICAgICAgICAgICAgZGxib3cgPQ0KPj4gKyAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBwb29sX2NvbmZpZy0+ZGlzYWJsZV9sb2FkX2JhbGFu Y2Vfb25fd3JpdGU7DQo+PiArICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIExpc3QgICAg ICAgKndsaXN0ID0NCj4+ICsNCj4+ICBzZXNzaW9uX2NvbnRleHQtPnRyYW5zYWN0aW9uX3RlbXBf d3JpdGVfbGlzdDsNCj4+ICsNCj4+ICsgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgaWYg KGRsYm93ID09IERMQk9XX0RNTF9BREFQVElWRV9HTE9CQUwgJiYNCj4+ICsgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBpc19jb21taXRfcXVlcnkobm9kZSkgJiYNCj4+ICsg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB3bGlzdCAhPSBOSUwpDQo+PiAr ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHsNCj4+ICsgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICBMaXN0Q2VsbCAgICpjZWxsOw0KPj4gKyAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIGludCAgICAgICAgICAgICAgICAgICAgIGRib2lkOw0K Pj4gKw0KPj4gKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGRib2lkID0N Cj4+ICsNCj4+ICBwb29sX3RyYWNrX3RhYmxlX211dGF0aW9uX2dldF9kYXRhYmFzZV9vaWQoKTsN Cj4+ICsgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBpZiAoZGJvaWQgPiAw KQ0KPj4gKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHsNCj4+ICsgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGZvcmVhY2goY2VsbCwg d2xpc3QpDQo+PiArICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICB7DQo+PiArICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIGNoYXIgICAgICAgKnRuYW1lOw0KPj4gKyAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBpbnQNCj4+ICAgICAgdG9pZDsNCj4+ICsNCj4+ ICsgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg dG5hbWUgPSAoY2hhciAqKQ0KPj4gbGZpcnN0KGNlbGwpOw0KPj4gKyAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB0b2lkID0NCj4+ICsNCj4+ICBw b29sX3RhYmxlX25hbWVfdG9fb2lkKHRuYW1lKTsNCj4+ICsNCj4+ICsgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgaWYgKHRvaWQgPiAwKQ0KPj4g Kw0KPj4gIHBvb2xfdHJhY2tfdGFibGVfbXV0YXRpb25fbWFya190YWJsZV93cml0dGVuKA0KPj4g Kw0KPj4NCj4+ICAgdG9pZCwgZGJvaWQpOw0KPj4gKyAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgfQ0KPj4NCj4+IFRoZSBjb2RlIHBhdGggaXMgZXhlY3V0ZWQg YmVmb3JlIHRoZSBjb21taXQgY29tbWFuZCBpcyBzZW50IHRvIHByaW1hcnkNCj4+IFBvc3RncmVT UUwuIEkgd29uZGVyIHdoYXQgd2lsbCBoYXBwZW4gaWYgdGhlIGNvbW1pdCBjb21tYW5kIGZhaWxl ZD8NCj4+IEV4YW1wbGU6DQo+Pg0KPj4gQ1JFQVRFIFRFTVAgVEFCTEUgdDEoaSBpbnQgUFJJTUFS WSBLRVkgREVGRVJSQUJMRSBJTklUSUFMTFkgREVGRVJSRUQpOw0KPj4gQ1JFQVRFIFRBQkxFDQo+ PiBJTlNFUlQgSU5UTyB0MSBWQUxVRVMoMSk7DQo+PiBJTlNFUlQgMCAxDQo+PiBCRUdJTjsNCj4+ IEJFR0lODQo+PiBJTlNFUlQgSU5UTyB0MSBWQUxVRVMoMSk7DQo+PiBJTlNFUlQgMCAxDQo+PiBJ TlNFUlQgSU5UTyB0MSBWQUxVRVMoMik7DQo+PiBJTlNFUlQgMCAxDQo+PiBDT01NSVQ7DQo+PiBw c3FsOmRlZmVyYWJsZS5zcWw6NjogRVJST1I6ICBkdXBsaWNhdGUga2V5IHZhbHVlIHZpb2xhdGVz IHVuaXF1ZQ0KPj4gY29uc3RyYWludCAidDFfcGtleSINCj4+IERFVEFJTDogIEtleSAoaSk9KDEp IGFscmVhZHkgZXhpc3RzLg0KPj4NCj4+IEFzIHlvdSBjYW4gc2VlLCB0aGUgQ09NTUlUIGNvbW1h bmQgZmFpbGVkIGFuZCB0aGUgZWZmZWN0IG9mIElOU0VSVA0KPj4gY29tbWFuZHMgdmFuaXNoZWQg dG9vLiBIb3dldmVyIHRoZSBjb2RlIGludmFsaWRhdGVzIHRoZSBkYXRhIG9uIHRoZQ0KPj4gc2hh cmVkIG1lbW9yeSBieSBwb29sX3RyYWNrX3RhYmxlX211dGF0aW9uX21hcmtfdGFibGVfd3JpdHRl bigpIHdoZW4NCj4+IGl0IHNob3VsZCBub3QgYmUgY2FsbGVkPw0KPj4NCj4+IFJlZ2FyZHMsDQo+ PiAtLQ0KPj4gVGF0c3VvIElzaGlpDQo+PiBTUkEgT1NTIEsuSy4NCj4+IEVuZ2xpc2g6IGh0dHA6 Ly93d3cuc3Jhb3NzLmNvLmpwL2luZGV4X2VuLw0KPj4gSmFwYW5lc2U6aHR0cDovL3d3dy5zcmFv c3MuY28uanANCj4+DQo+IA0KPiANCj4gLS0gDQo+IE5hZGF2IFNoYXR6DQo+IFRhaWxvciBCcmFu ZHMgfCBDVE8NCg==