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 1vkxnV-0056Cs-35 for pgpool-hackers@arkaria.postgresql.org; Wed, 28 Jan 2026 05:08:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vkxnS-00HRv5-2K for pgpool-hackers@arkaria.postgresql.org; Wed, 28 Jan 2026 05:08:55 +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.96) (envelope-from ) id 1vkxnS-00HRuy-1X for pgpool-hackers@lists.postgresql.org; Wed, 28 Jan 2026 05:08:54 +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 1vkxnO-002gI7-2G for pgpool-hackers@lists.postgresql.org; Wed, 28 Jan 2026 05:08:53 +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=RgHIbO5negS7npUc2GsNWoRK2OFIYaF3Eoo6wjTRZx4=; b=ZIE797KbotwtvjWE03NFDn0Dyd 81ug4nTNgcd+B3H6+sn00x0o6jWesIT7bc85vh9bTsw+1bDdvksnABxGUh0Vx3Ijr0kwNzQi/d+ZX IsgHTDsE94n0rM2i89i7givw2ZHJBB8OSBNcnBOqrUg0f9NtzHLSHdJgX0Nu1N1A7iYgMKcUmPSi7 L/jton17VjZj+D0yOIS+tf+Sc9iK3iqZTrvXHJ1wxgJM1kei3fiOUPURjTrUJFCgEQUhTbueUgZ3S ZMOoACYeKveGo/FO7NAnsEo1TeDmk7nQ3qOrOdUsw5tymcB5h3xtRBo/pO+mrkEg3pYJAmIRtNl/f IjPbF31g==; Received: from 117.141.178.217.shared.user.transix.jp ([217.178.141.117] 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 1vkxnL-006CAF-0c; Wed, 28 Jan 2026 05:08:50 +0000 Date: Wed, 28 Jan 2026 14:08:40 +0900 (JST) Message-Id: <20260128.140840.463288103359200425.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: 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 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgTmFkYXYsDQoNClNvcnJ5IGZvciB0aGUgbGF0ZSByZXBseS4gSSBqdXN0IHlvdXIgZW1haWwg bm93LiBXaWxsIGNoZWNrIGFuZCByZXBseQ0KYmFjayBzb29uLg0KLS0NClRhdHN1byBJc2hpaQ0K U1JBIE9TUyBLLksuDQpFbmdsaXNoOiBodHRwOi8vd3d3LnNyYW9zcy5jby5qcC9pbmRleF9lbi8N CkphcGFuZXNlOmh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwDQoNCj4gSGkgYWxsLA0KPiANCj4gQW55 IGNvbW1lbnRzIG9yIGNvbmNlcm5zPyBjYW4gd2UgbWVyZ2UgaXQgaWYgbm90Pw0KPiANCj4gT24g VHVlLCBKYW4gNiwgMjAyNiBhdCAxOjI14oCvUE0gTmFkYXYgU2hhdHogPG5hZGF2QHRhaWxvcmJy YW5kcy5jb20+IHdyb3RlOg0KPiANCj4+IEhlbGxvLA0KPj4NCj4+IEFzIGluaXRpYWxseSBwcm9w b3NlZCB1bmRlciAiUHJvcG9zYWw6IHJlY2VudCBhY2Nlc3MgYmFzZWQgcm91dGluZyBmb3INCj4+ IHByaW1hcnktcmVwbGljYSBzZXR1cHMiIGFuZCB0aGVuIGJyb2tlbiBpbnRvIHNlcGFyYXRlIHRh c2tzIC0gaSBhbSBhZGRpbmcNCj4+IGhlcmUgYSBwYXRjaCB0byBpbXBsZW1lbnQgdHJhY2tpbmcg b2YgbGF0ZXN0IG11dGF0ZWQgdGFibGUsIGFuZCB0aGVuIHVzaW5nDQo+PiB0aGUgcmVwbGljYXRp b24gbGFnIGFzIGEgYmFzZSAtIGRlY2lkaW5nIHdoZXJlIHRvIHBvaW50IHF1ZXJpZXMgd2hlbiBx dWVyeQ0KPj4gbG9hZCBiYWxhbmNpbmcgYW5kIHBhcnNpbmcgaXMgZW5hYmxlZC4NCj4+DQo+PiBN b3JlIGRldGFpbHMgYXMgaW4gdGhlIHBhdGNoOg0KPj4gRmVhdHVyZTogYWRkIGluLW1lbW9yeSB0 YWJsZSB0cmFja2luZyB0byBwcmV2ZW50IHN0YWxlIHJlYWRzIGZyb20gcmVwbGljYXMNCj4+DQo+ PiBJbXBsZW1lbnQgIm1lbW9yeSBtYXAiIGZlYXR1cmUgdGhhdCB0cmFja3MgcmVjZW50bHktd3Jp dHRlbiBkYXRhYmFzZQ0KPj4gdGFibGVzIGluIHNoYXJlZCBtZW1vcnkgdG8gcHJldmVudCBzdGFs ZSByZWFkcyBkdXJpbmcgcmVwbGljYXRpb24gbGFnLg0KPj4gV2hlbiBhIHdyaXRlIChJTlNFUlQv VVBEQVRFL0RFTEVURSkgb2NjdXJzIG9uIGEgdGFibGUsIHRoYXQgdGFibGUgaXMNCj4+IG1hcmtl ZCBhcyAiZGlydHkiIGZvciBhIGNvbmZpZ3VyYWJsZSBUVEwgcGVyaW9kLiBBbnkgU0VMRUNUIG9u IGEgZGlydHkNCj4+IHRhYmxlIHdpdGhpbiB0aGUgVFRMIHdpbmRvdyBpcyByb3V0ZWQgdG8gcHJp bWFyeSBpbnN0ZWFkIG9mIHJlcGxpY2EuDQo+Pg0KPj4gS2V5IGZlYXR1cmVzOg0KPj4gLSBTaGFy ZWQgbWVtb3J5IGhhc2ggdGFibGUgZm9yIHRyYWNraW5nIHRhYmxlIG11dGF0aW9ucyB3aXRoIFRU TA0KPj4gLSBRdWVyeSBwYXJzZSBjYWNoZSB3aXRoIExSVSBldmljdGlvbiBmb3IgcGVyZm9ybWFu Y2UNCj4+IC0gQ29sZCBzdGFydCBwcm90ZWN0aW9uIChyb3V0ZXMgYWxsIHF1ZXJpZXMgdG8gcHJp bWFyeSBpbml0aWFsbHkpDQo+PiAtIEF1dG9tYXRpYyBUVEwgY2FsY3VsYXRpb246IHJlcGxpY2F0 aW9uX2RlbGF5IMOXIGNvbmZpZ3VyYWJsZSBmYWN0b3INCj4+IC0gUGVyLXRhYmxlIHN0YWxlbmVz cyB0cmFja2luZyB3aXRoIG1pY3Jvc2Vjb25kIHByZWNpc2lvbg0KPj4NCj4+IE5ldyBjb25maWd1 cmF0aW9uIHBhcmFtZXRlcnM6DQo+PiAtIG1lbW9yeV9tYXBfZW5hYmxlZDogRW5hYmxlL2Rpc2Fi bGUgdGhlIGZlYXR1cmUgKGRlZmF1bHQ6IG9mZikNCj4+IC0gbWVtb3J5X21hcF90dGxfZmFjdG9y OiBUVEwgbXVsdGlwbGllciBmb3IgcmVwbGljYXRpb24gZGVsYXkgKGRlZmF1bHQ6DQo+PiA1LjAp DQo+PiAtIG1lbW9yeV9tYXBfY29sZF9zdGFydF9kdXJhdGlvbjogQ29sZCBzdGFydCBwZXJpb2Qg aW4gbXMgKGRlZmF1bHQ6IDIwMDApDQo+PiAtIG1lbW9yeV9tYXBfdGFibGVfYnVja2V0czogSGFz aCBidWNrZXRzIGZvciB0YWJsZSBtYXAgKGRlZmF1bHQ6IDEwMjQpDQo+PiAtIG1lbW9yeV9tYXBf dGFibGVfc2l6ZTogTWF4IHRyYWNrZWQgdGFibGVzIChkZWZhdWx0OiAyMDQ4KQ0KPj4gLSBtZW1v cnlfbWFwX3F1ZXJ5X2J1Y2tldHM6IEhhc2ggYnVja2V0cyBmb3IgcXVlcnkgY2FjaGUgKGRlZmF1 bHQ6IDIwNDgpDQo+PiAtIG1lbW9yeV9tYXBfcXVlcnlfY2FjaGVfc2l6ZTogTWF4IGNhY2hlZCBx dWVyaWVzIChkZWZhdWx0OiAxMDAwMCkNCj4+DQo+PiBQYXRjaCBhcHBsaWVzIHByb3Blcmx5IGFu ZCB0ZXN0cyBwYXNzLg0KPj4NCj4+IE9wZW4gdG8gYWxsIGZlZWRiYWNrIC0gdGhhbmsgeW91IQ0K Pj4NCj4+IC0tDQo+PiBOYWRhdiBTaGF0eg0KPj4gVGFpbG9yIEJyYW5kcyB8IENUTw0KPj4NCj4g DQo+IA0KPiAtLSANCj4gTmFkYXYgU2hhdHoNCj4gVGFpbG9yIEJyYW5kcyB8IENUTw0K