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 1vq7Ss-004wlW-1j for pgpool-hackers@arkaria.postgresql.org; Wed, 11 Feb 2026 10:29:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vq7Sr-003Ku3-2B for pgpool-hackers@arkaria.postgresql.org; Wed, 11 Feb 2026 10:28:58 +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 1vq7Sr-003Ktq-1c for pgpool-hackers@lists.postgresql.org; Wed, 11 Feb 2026 10:28:58 +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 1vq7Sp-000000008Gt-1wq4 for pgpool-hackers@lists.postgresql.org; Wed, 11 Feb 2026 10:28:58 +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=fpl9ySlNYlfTN9jwbqUYpD3xtGvHYrTezOOvl/bQdKQ=; b=kRYzj+FwTGTxZFvAT2LqMltmY6 VYdP9HmPOGwgPAZ43B7pJ784NXybH5eOJkBTTfGBa7yQMKuzVeZGI0wqPYIH68m4h//XhNIvV7VfD WFFvNIps3J8Vfe0V6QIUwx9RI3zdGGiO28Z/AWhjFHuJEaYVyd51PnpYap9SyKohXf1iWoJD9pqiN qelOMsSLVqbRaIQi/GizVCcqtKy9jaNPcDtwIsAoD+V34Jb+xL3xAtmIvn80ranNyya2MN2GtK5nL oIX+aFKKvEC+oka6FHsAniAiaa6JpXrlk5exejDeNSabFQf5X3Og5X6wK5QgFNWvdDZ653Id51BAT 1GePbh3A==; Received: from [2409:11:4120:300:968e:efa2:38a6:c725] (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 1vq7Sm-000K5p-0G; Wed, 11 Feb 2026 10:28:55 +0000 Date: Wed, 11 Feb 2026 19:28:45 +0900 (JST) Message-Id: <20260211.192845.1888610184173239311.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: <20260204.082343.1732190257543250666.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:968e:efa2:38a6:c725 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBIaSBUYXRzdW8sDQo+IA0KPiBBZnRlciByZWFkaW5nIG1vcmUgYWJvdXQgZGlzYWJsZV9sb2Fk X2JhbGFuY2Vfb25fd3JpdGU9ZG1sX2FkYXB0aXZlIGkgY2FtZQ0KPiB0byB0aGUgdGhvdWdodCB0 aGF0IHRoaXMgZmVhdHVyZSBpcyBhY3R1YWxseSBhbiAiZXh0ZW5zaW9uIiBvZiB0aGF0IHNpbmNl DQo+IGl0IGNvdmVycyAiZ2xvYmFsIiBhbmQgbm90IGp1c3QgcGVyIHRyYW5zYWN0aW9uIGJlaGF2 aW9yLiBpbiBhbnkgY2FzZSBpDQo+IHRoaW5rIGl0IG1ha2VzIG1vcmUgc2Vuc2UgdGhhdCBpdCBz aXRzIHVuZGVyDQo+IHRoZSBkaXNhYmxlX2xvYWRfYmFsYW5jZV9vbl93cml0ZSBhbmQgbm90IGFz IGEgc3RhbmRhbG9uZSBmb3IgY2xhcml0eS4NCj4gDQo+IEknbSBhdHRhY2hpbmcgYmVsb3cgYW4g dXBkYXRlZCBwYXRjaCB3aXRoIHRoZXNlIGFkanVzdG1lbnRzLg0KPiANCj4gUGxlYXNlIGxldCBt ZSBrbm93IHdoYXQgeW91IHRoaW5rLg0KDQpJIHdvcnJ5IGFib3V0IHRoZSB0cmFuc2FjdGlvbmFs IGJlaGF2aW9yIHdpdGggdGhlIHBhdGNoOg0KDQorICAgIFRoaXMgbWVhbnMgdGhhdCBpZiBhIHRy YW5zYWN0aW9uIGlzIHJvbGxlZCBiYWNrLCB0aGUgdGFibGUgcmVtYWlucyBtYXJrZWQgYXMgc3Rh bGUgdW50aWwNCisgICAgdGhlIFRUTCBleHBpcmVzLCBldmVuIHRob3VnaCBubyBhY3R1YWwgZGF0 YSBtb2RpZmljYXRpb24gb2NjdXJyZWQuIFRoaXMgaXMgYnkgZGVzaWduOg0KDQpUaGlzIGFsbG93 cyBhdHRhY2tlcnMgdG8gaXNzdWUgc2ltcGxlIGNvbW1hbmQgY29udGludW91c2x5IHRvDQplZmZl Y3RpdmVseSBkaXNhYmxlIGxvYWQgYmFsYW5jZSAoYW5kIGluY3JlYXNlIHRoZSBsb2FkIG9mIHBy aW1hcnkpIGluDQp3aG9sZSBzeXN0ZW06DQoNCkJFR0lOOw0KVVBEQVRFIHQxIFNFVCBpID0gMSBX SEVSRSBGQUxTRTsNClJPTExCQUNLOw0KDQpJIHRoaW5rIGlmIHRoZSBwYXRjaCBhbGxvd3MgdGhh dCwgd2UgY2Fubm90IGFjY2VwdCB0aGUgcGF0Y2guDQoNCkJlc3QgcmVnYXJkcywNCi0tDQpUYXRz dW8gSXNoaWkNClNSQSBPU1MgSy5LLg0KRW5nbGlzaDogaHR0cDovL3d3dy5zcmFvc3MuY28uanAv aW5kZXhfZW4vDQpKYXBhbmVzZTpodHRwOi8vd3d3LnNyYW9zcy5jby5qcA0KDQo+IE9uIEZyaSwg RmViIDYsIDIwMjYgYXQgMToyOeKAr1BNIE5hZGF2IFNoYXR6IDxuYWRhdkB0YWlsb3JicmFuZHMu Y29tPiB3cm90ZToNCj4gDQo+PiBIaSBUYXRzdW8sDQo+Pg0KPj4gVGhhbmsgeW91IGZvciBhbGwg dGhlIGdyZWF0IGNvbW1lbnRzIGFuZCBxdWVzdGlvbnMhIEkgdG9vayB1bmRlcg0KPj4gY29uc2lk ZXJhdGlvbiBhbGwgb2YgdGhlbSBlaXRoZXIgYWRkaW5nIHN1cHBvcnQvdGVzdHMgb3IgZGV0YWls aW5nIHRoZQ0KPj4gbGltaXRhdGlvbnMgaW4gdGhlIGRvY3MuDQo+Pg0KPj4gTGV0IG1lIGtub3cg d2hhdCB5b3UgdGhpbmsgb2YgdGhlIGxhdGVzdCBwYXRjaCBhdHRhY2hlZCBoZXJlDQo+Pg0KPj4g T24gV2VkLCBGZWIgNCwgMjAyNiBhdCAxOjIz4oCvQU0gVGF0c3VvIElzaGlpIDxpc2hpaUBwb3N0 Z3Jlc3FsLm9yZz4gd3JvdGU6DQo+Pg0KPj4+IEZyb206IFRhdHN1byBJc2hpaSA8aXNoaWlAcG9z dGdyZXNxbC5vcmc+DQo+Pj4gU3ViamVjdDogUmU6IFByb3Bvc2FsOiBSZWNlbnQgbXV0YXRlZCB0 YWJsZSB0cmFja2luZyBpbiBtZW1vcnkNCj4+PiBEYXRlOiBUdWUsIDAzIEZlYiAyMDI2IDE2OjQz OjUzICswOTAwIChKU1QpDQo+Pj4gTWVzc2FnZS1JRDogPDIwMjYwMjAzLjE2NDM1My4zNjI5NDM4 MTg0NjYxMTc3NzMuaXNoaWlAcG9zdGdyZXNxbC5vcmc+DQo+Pj4NCj4+PiA+IEhpIE5hZGF2LA0K Pj4+ID4NCj4+PiA+IFRoYW5rIHlvdSBmb3IgdXBkYXRpbmcgdGhlIHBhdGNoIQ0KPj4+ID4NCj4+ PiA+PiBUaGFuayB5b3UgZm9yIHRoZSBjb21tZW50cyENCj4+PiA+Pg0KPj4+ID4+IEkgYWdyZWUg d2l0aCBhbGwgb2YgdGhlbS4gTGV0IG1lIGtub3cgd2hhdCB5b3UgdGhpbmsgb2YgdGhlIGNoYW5n ZXMNCj4+PiBhbmQgbmV3DQo+Pj4gPj4gbmFtaW5nLg0KPj4+ID4NCj4+PiA+IEkgc3RpbGwgdGhp bmsgIm1lbW9yeV9tYXAiIGlzIHRvbyBnZW5lcmljLiBBbnl0aGluZyBwdXQgb24gbWVtb3J5IGZv cg0KPj4+ID4gZGF0YSBtYXBwaW5nIGNvdWxkIGJlIGNhbGxlZCAibWVtb3J5IG1hcCIuIEkgcmVj b21tZW5kIHRvIGNoYW5nZSB0aGUNCj4+PiA+IG5hbWUgdG8gbW9yZSBmZWF0dXJlIHNwZWNpZmlj IG9uZTogV2hhdCBhYm91dCByZXBsYWNpbmcgIm1lbW9yeV9tYXAiDQo+Pj4gPiB3aXRoICJ0cmFj a190YWJsZV9tdXRhdGlvbiI/IEl0J3MgYSBsaXR0bGUgYml0IGxvbmdlciBuYW1lIGJ1dCBpdA0K Pj4+ID4gY2xlYXJseSByZXByZXNlbnRzIHRoZSBmZWF0dXJlLiBBbnkgYmV0dGVyIGlkZWFzIGFy ZSB3ZWxjb21lLg0KPj4+ID4NCj4+PiA+IC0gbWVtb3J5X21hcF9lbmFibGVkOiBFbmFibGUvZGlz YWJsZSB0aGUgZmVhdHVyZSAoZGVmYXVsdDogb2ZmKQ0KPj4+ID4gLSBtZW1vcnlfbWFwX3R0bF9m YWN0b3I6IFRUTCBtdWx0aXBsaWVyIGZvciByZXBsaWNhdGlvbiBkZWxheSAoZGVmYXVsdDoNCj4+ PiA1LjApDQo+Pj4gPiAtIG1lbW9yeV9tYXBfY29sZF9zdGFydF9kdXJhdGlvbjogQ29sZCBzdGFy dCBwZXJpb2QgaW4gbXMgKGRlZmF1bHQ6DQo+Pj4gMjAwMCkNCj4+PiA+IC0gbWVtb3J5X21hcF90 YWJsZV9idWNrZXRzOiBIYXNoIGJ1Y2tldHMgZm9yIHRhYmxlIG1hcCAoZGVmYXVsdDogMTAyNCkN Cj4+PiA+IC0gbWVtb3J5X21hcF90YWJsZV9zaXplOiBNYXggdHJhY2tlZCB0YWJsZXMgKGRlZmF1 bHQ6IDIwNDgpDQo+Pj4gPiAtIG1lbW9yeV9tYXBfcXVlcnlfYnVja2V0czogSGFzaCBidWNrZXRz IGZvciBxdWVyeSBjYWNoZSAoZGVmYXVsdDogMjA0OCkNCj4+PiA+IC0gbWVtb3J5X21hcF9xdWVy eV9jYWNoZV9zaXplOiBNYXggY2FjaGVkIHF1ZXJpZXMgKGRlZmF1bHQ6IDEwMDAwKQ0KPj4+ID4N Cj4+PiA+IEFsc28gSSBmZWVsIG1lbW9yeV9tYXBfcXVlcnlfY2FjaGVfc2l6ZSBpcyBjb25mdXNp bmcgYmVjYXVzZSB0aGVyZSdzDQo+Pj4gPiBhbHJlYWR5ICJxdWVyeSBjYWNoZSIgZmVhdHVyZSBp biBwZ3Bvb2wuICBDYW4gd2UgY2hhbmdlIGl0IHNvbWV0aGluZw0KPj4+ID4gbGlrZSAicXVlcnlf cGFyc2VfY2FjaGVfc2l6ZSI/DQo+Pj4gPg0KPj4+ID4gUmV2aWV3IGNvbW1lbnRzOg0KPj4+ID4N Cj4+PiA+ICgxKSBXaHkgdGhlIHJlZ3Jlc3Npb24gdGVzdCBpcyA0NT8gU2hvdWxkbid0IGl0IGJl IDQyPyAodGhlIGxhc3QNCj4+PiA+IGZlYXR1cmUgdGVzdCBpcyAwNDEuZXh0ZXJuYWxfcmVwbGlj YXRpb25fZGVsYXkpLg0KPj4+ID4NCj4+PiA+ICgyKSBZb3UgZW5oYW5jZSB0aGUgcGF0Y2ggdG8g ZGVhbCB3aXRoIGxlYWRlciB3YXRjaCBjaGFuZ2luZy4gVGhhdCdzDQo+Pj4gPiBnb29kLiBIb3dl dmVyLCBJIGRvbid0IHNlZSBhIHRlc3QgY2FzZSBmb3IgaXQgaW4gdGVzdC5zaC4NCj4+PiA+DQo+ Pj4gPiAoMykgSXQgc2VlbXMgdGhlIHBhdGNoIGRvZXMgbm90IHN1cHBvcnQgVFJVTkNBVEUsIE1F UkdFLCBQUkVQQVJFIGFuZA0KPj4+ID4gV0lUSCArIHVwZGF0aW5nLiBJZiBzbywgaXQgc2hvdWxk IGJlIG5vdGVkIGluIHRoZSBkb2NzIGFzIGEgbGltaXRhdGlvbg0KPj4+ID4gb2YgdGhlIGZlYXR1 cmUuDQo+Pj4NCj4+PiAoNCkgSXQgc2VlbXMgdGhlIHBhdGNoIGRvZXMgbm90IGNvbnNpZGVyIHRy YW5zYWN0aW9ucy4gSWYgYW4gVVBEQVRFIGlzDQo+Pj4gcGVyZm9ybWVkIGluIGEgdHJhbnNhY3Rp b24gYW5kIHRoZSB0cmFuc2FjdGlvbiBnZXRzIHJvbGxiYWNrZWQsIGxvYWQNCj4+PiBiYWxhbmNl IGlzIGRpc2FibGVkIGRlc3BpdGUgdGhhdCBmYWN0IHRoYXQgdGhlIHRhYmxlIG1vZGlmaWNhdGlv biBkaWQNCj4+PiBub3QgaGFwcGVuLg0KPj4+DQo+Pj4gQmVzdCByZWdhcmRzLA0KPj4+IC0tDQo+ Pj4gVGF0c3VvIElzaGlpDQo+Pj4gU1JBIE9TUyBLLksuDQo+Pj4gRW5nbGlzaDogaHR0cDovL3d3 dy5zcmFvc3MuY28uanAvaW5kZXhfZW4vDQo+Pj4gSmFwYW5lc2U6aHR0cDovL3d3dy5zcmFvc3Mu Y28uanANCj4+Pg0KPj4NCj4+DQo+PiAtLQ0KPj4gTmFkYXYgU2hhdHoNCj4+IFRhaWxvciBCcmFu ZHMgfCBDVE8NCj4+DQo+IA0KPiANCj4gLS0gDQo+IE5hZGF2IFNoYXR6DQo+IFRhaWxvciBCcmFu ZHMgfCBDVE8NCg==