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 1tqAWh-000WuB-GW for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Mar 2025 12:40: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 1tqAWf-00A9ry-C7 for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Mar 2025 12:40:33 +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 1tqAWe-00A9nZ-Rf for pgsql-hackers@lists.postgresql.org; Thu, 06 Mar 2025 12:40:33 +0000 Received: from smtp-fw-80009.amazon.com ([99.78.197.220]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tqAWY-001IWM-17 for pgsql-hackers@postgresql.org; Thu, 06 Mar 2025 12:40:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1741264826; x=1772800826; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=JOy87SR1KsmnO2J4Bh3aDuTt6XaetWsWDU17OqDAt2A=; b=v7tyYNGtjsrAabjdfiJP6GeRsQ9CJFZopat9IdWiHWblMnrwTWxTBBRB bGk0TzW+SIgwzbuxfqklzYuShY+eNpGu50myG9FZvOVdLcZM5EHu7SvO7 CuLF3LWwILTPRSWf0hE+LdHF86VuHYl47T5phN+HBtAWIg4MOdEdHahhk A=; X-IronPort-AV: E=Sophos;i="6.14,226,1736812800"; d="scan'208";a="179026305" Subject: Re: Expanding HOT updates for expression and partial indexes Thread-Topic: Expanding HOT updates for expression and partial indexes Received: from pdx4-co-svc-p1-lb2-vlan2.amazon.com (HELO smtpout.prod.us-east-1.prod.farcaster.email.amazon.dev) ([10.25.36.210]) by smtp-border-fw-80009.pdx80.corp.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 06 Mar 2025 12:40:23 +0000 Received: from EX19MTAUEA001.ant.amazon.com [10.0.29.78:36391] by smtpin.naws.us-east-1.prod.farcaster.email.amazon.dev [10.0.95.161:2525] with esmtp (Farcaster) id 188d3efe-766b-4bf4-846e-f1fd29e400a4; Thu, 6 Mar 2025 12:40:23 +0000 (UTC) X-Farcaster-Flow-ID: 188d3efe-766b-4bf4-846e-f1fd29e400a4 Received: from EX19D018UEC002.ant.amazon.com (10.252.135.229) by EX19MTAUEA001.ant.amazon.com (10.252.134.203) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1544.14; Thu, 6 Mar 2025 12:40:23 +0000 Received: from EX19D018UEC003.ant.amazon.com (10.252.135.218) by EX19D018UEC002.ant.amazon.com (10.252.135.229) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1544.14; Thu, 6 Mar 2025 12:40:22 +0000 Received: from EX19D018UEC003.ant.amazon.com ([fe80::ea09:1bf7:c4d8:3004]) by EX19D018UEC003.ant.amazon.com ([fe80::ea09:1bf7:c4d8:3004%3]) with mapi id 15.02.1544.014; Thu, 6 Mar 2025 12:40:22 +0000 From: "Burd, Greg" To: Matthias van de Meent CC: "pgsql-hackers@postgresql.org" Thread-Index: AQHbgjA8Gt6ExU8qBkWj3c8Md8j0M7NlSy2AgADaQAA= Date: Thu, 6 Mar 2025 12:40:22 +0000 Message-ID: References: <78574B24-BE0A-42C5-8075-3FA9FA63B8FC@amazon.com> <238EEE41-B206-4590-8C20-DA52C25A2291@amazon.com> <51C77060-059F-4BB3-8EAF-83F08656F6D2@amazon.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.95.185.130] Content-Type: text/plain; charset="utf-8" Content-ID: <58BF204840FEFC40A2E07EA4D448D12C@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk DQo+IE9uIE1hciA1LCAyMDI1LCBhdCA2OjM54oCvUE0sIE1hdHRoaWFzIHZhbiBkZSBNZWVudCA8 Ym9la2V3dXJtK3Bvc3RncmVzQGdtYWlsLmNvbT4gd3JvdGU6DQo+IA0KPiBPbiBXZWQsIDUgTWFy IDIwMjUgYXQgMTg6MjEsIEJ1cmQsIEdyZWcgPGdyZWdidXJkQGFtYXpvbi5jb20+IHdyb3RlOg0K Pj4gDQo+PiBIZWxsbywNCj4+IA0KPj4gSSd2ZSByZWJhc2VkIGFuZCB1cGRhdGVkIHRoZSBwYXRj aCBhIGJpdC4gIFRoZSBiaWdnZXN0IGNoYW5nZSBpcyB0aGF0IHRoZSBwZXJmb3JtYW5jZSBwZW5h bHR5IG1lYXN1cmVkIHdpdGggdjEgb2YgdGhpcyBwYXRjaCBpcyBlc3NlbnRpYWxseSBnb25lIGlu IHYxMC4gIFRoZSBvdmVyaGVhZCB3YXMgZHVlIHRvIHJlLWNyZWF0aW5nIEluZGV4SW5mbyBpbmZv cm1hdGlvbiB1bm5lY2Vzc2FyaWx5LCB3aGljaCBJIGZvdW5kIGV4aXN0ZWQgaW4gdGhlIGVzdGF0 ZS4gIEkndmUgYWRkZWQgYSBmZXcgZmllbGRzIGluIEluZGV4SW5mbyB0aGF0IGFyZSBub3QgcG9w dWxhdGVkIGJ5IGRlZmF1bHQgYnV0IG5lY2Vzc2FyeSB3aGVuIGNoZWNraW5nIGV4cHJlc3Npb24g aW5kZXhlcywgdGhvc2UgZmllbGRzIGFyZSBwb3B1bGF0ZWQgb24gZGVtYW5kIGFuZCBvbmx5IG9u Y2UgbGltaXRpbmcgdGhlaXIgb3ZlcmhlYWQuDQo+IA0KPiBUaGlzIHJldmlldyBpcyBiYXNlZCBv biBhIGxpZ2h0IHJlYWRpbmcgb2YgcGF0Y2ggdjEwLiBJIGhhdmUgbm90IHJlYWQNCj4gYWxsIDkw a0IsIGFuZCBhbSB1bmxpa2VseSB0byBmaW5pc2ggYSBmdWxsIHJldmlldyBzb29uOg0KPiANCj4+ ICogYXNzdW1lcyBlc3RhdGUtPmVzX3Jlc3VsdF9yZWxhdGlvbnNbMF0gaXMgdGhlIFJlc3VsdFJl bEluZm8gYmVpbmcgdXBkYXRlZA0KPiANCj4gSSdtIG5vdCBzdXJlIHRoYXQncyBhIHZhbGlkIGFz c3VtcHRpb24uIEkgc3VzcGVjdCBpdCBtaWdodCBiZSBmYWxzZSBpbg0KPiBjYXNlcyBvZiBuZXN0 ZWQgdXBkYXRlcywgbGlrZQ0KPiANCj4gJCBVUERBVEUgdGFibGUxIFNFVCB2YWx1ZSA9IG90aGVy LnZhbHVlIEZST00gKFVQREFURSB0YWJsZTIgU0VUIHZhbHVlDQo+ID0gMiApIG90aGVyIFdIRVJF IG90aGVyLmlkID0gdGFibGUxLmlkOw0KPiANCj4gSWYgdGhpcyB0YWJsZTEgb3IgdGFibGUyIGhh cyBleHByZXNzaW9uIGluZGV4ZXMgSSBzdXNwZWN0IGl0IG1heQ0KPiByZXN1bHQgaW4gdGhpcyBh c3NlcnRpb24gZmFpbGluZyAoYnV0IEkgaGF2ZW4ndCBzcHVuIHVwIGEgc2VydmVyIHdpdGgNCj4g dGhlIHBhdGNoKS4NCj4gQWx0ZXJuYXRpdmVseSwgcGxlYXNlIGFsc28gY2hlY2sgdGhhdCBpdCBk b2Vzbid0IGJyZWFrIGlmIGFueSBvZiB0aGVzZQ0KPiB0d28gdGFibGVzIGlzIHBhcnRpdGlvbmVk IHdpdGggbXVsdGlwbGUgcGFydGl0aW9ucyAoYW5kL29yIGhhcw0KPiBleHByZXNzaW9uIGluZGV4 ZXMsIGV0Yy4pLg0KDQpWYWxpZCwgYW5kIHBvc3NpYmxlLiAgSSdsbCBjaGVjayBhbmQgZmluZCBh IHdheSB0byBwYXNzIGFsb25nIHRoZSBrbm93bi1jb3JyZWN0IFJSSSBpbmRleCBpbnRvIHRoYXQg YXJyYXkuDQoNCj4+ICogdXNlcyByaV9JbmRleFJlbGF0aW9uSW5mb1tdIGZyb20gd2l0aGluIGVz dGF0ZSByYXRoZXIgdGhhbiByZS1jcmVhdGluZyBpdA0KPiANCj4gQXMgSSBtZW50aW9uZWQgYWJv dmUsIEkgdGhpbmsgaXQncyBzYWZlciB0byBwYXNzIHRoZSBrbm93bi1jb3JyZWN0IFJSSQ0KPiAo a25vd24gYnkgY2FsbGVycyBvZiB0YWJsZV90dXBsZV91cGRhdGUpIGRvd24gdGhlIHN0YWNrLg0K DQpJIHRoaW5rIHBhc3NpbmcgdGhlIGtub3duLWNvcnJlY3QgUlJJIGluZGV4IGlzIHRoZSB3YXkg dG8gZ28gYXMgSSBuZWVkIGluZm9ybWF0aW9uIGZyb20gYm90aCByaV9JbmRleFJlbGF0aW9uSW5m by9EZXNjW10gYXJyYXlzLg0KDQo+PiAqIGF1Z21lbnRzIEluZGV4SW5mbyBvbmx5IHdoZW4gbmVl ZGVkIGZvciB0ZXN0aW5nIGV4cHJlc3Npb25zIGFuZCBvbmx5IG9uY2UNCj4gDQo+IEV4ZWNFeHBy ZXNzaW9uSW5kZXhlc1VwZGF0ZWQgc2VlbXMgdG8gYWx3YXlzIGxvb3Agb3ZlciBhbGwgaW5kZXhl cywNCj4gYWx3YXlzIGNhbGxpbmcgQXR0cmlidXRlSW5kZXhJbmZvIHdoaWNoIGFsd2F5cyB1cGRh dGVzIHRoZSBmaWVsZHMgaW4NCj4gdGhlIEluZGV4SW5mbyB3aGVuIHRoZSBpbmRleCBoYXMgb25s eSAhYnl2YWwgYXR0cmlidXRlcyAoZS5nLiB0ZXh0LA0KPiBqc29uLCBvciBvdGhlciBzdWNoIHZh cmxlbmEgdHlwZXMpLiBZb3Ugc2F5IGl0IGhhcHBlbnMgb25seSBvbmNlLCBoYXZlDQo+IEkgbWlz c2VkIHNvbWV0aGluZz8NCg0KVGhlcmUncyBhIHRlc3QgdGhhdCBhdm9pZHMgZG9pbmcgaXQgbW9y ZSB0aGFuIG9uY2UsIGJ1dCBJJ20gZ29pbmcgdG8gcmVuYW1lIHRoaXMgYXMgQnVpbGRFeHByZXNz aW9uSW5kZXhJbmZvKCkgYW5kIGNhbGwgaXQgZnJvbSBFeGVjT3BlbkluZGljZXMoKSBpZiB0aGVy ZSBhcmUgZXhwcmVzc2lvbnMgb24gdGhlIGluZGV4LiAgSSB0aGluayB0aGF0J3MgY2xlYW5lciBh bmQgdGhlcmUncyBwcmVjZWRlbnQgZm9yIGl0IGluIHRoZSBmb3JtIG9mIEJ1aWxkU3BlY3VsYXRp dmVJbmRleEluZm8oKS4NCg0KPiBJJ20gYWxzbyBzb21ld2hhdCBjb25jZXJuZWQgYWJvdXQgdGhl IHVzZSBvZiB0eXBlY2FjaGUgbG9va3VwcyBvbg0KPiBpbmRleC0+cmRfb3BjaW50eXBlW2ldLCBy YXRoZXIgdGhhbiB1c2luZw0KPiBUdXBsZURlc2NDb21wYWN0QXR0cihpbmRleC0+cmRfYXR0LCBp KTsgdGhlIGxhdHRlciBvZiB3aGljaCBJIHRoaW5rDQo+IHNob3VsZCBiZSBmYXN0ZXIsIGVzcGVj aWFsbHkgd2hlbiBtdWx0aXBsZSB3aWRlIGluZGV4ZXMgYXJlIHNjYW5uZWQNCj4gd2l0aCB2YXJp b3VzIGNvbHVtbiB0eXBlcy4gSW4gaG90IGxvb3BzIG9mIHNpbmdsZS10dXBsZSB1cGRhdGUNCj4g c3RhdGVtZW50cyBJIHRoaW5rIHRoaXMgbWF5IG1ha2UgYSBmZXcgMC4xJXB0IGRpZmZlcmVuY2Ug LSBub3QgYSBsb3QsDQo+IGJ1dCB3b3J0aCBjb25zaWRlcmluZy4NCg0KSSB3YXMganVzdCB3b3Jr aW5nIG9uIHRoYXQuICBHb29kIGlkZWEuDQoNCj4+ICogb25seSBjcmVhdGVzIGEgbG9jYWwgb2xk L25ldyBUdXBsZVRhYmxlU2xvdCB3aGVuIG5vdCBwcmVzZW50IGluIGVzdGF0ZQ0KPiANCj4gSSdt IG5vdCBzdXJlIGl0J3Mgc2FmZSBmb3IgdXMgdG8gdG91Y2ggdGhhdCBSUkkncyB0dXBsZXNsb3Rz Lg0KDQpNZSBuZWl0aGVyLCB0aGF0J3Mgd2h5IEkgbWVudGlvbmVkIGl0LiAgSXQgd2FzIG15IGF0 dGVtcHQgdG8gYXZvaWQgdGhlIHdvcmsgdG8gY3JlYXRlL2Rlc3Ryb3kgdGVtcCBzbG90cyBvdmVy IGFuZCBvdmVyIHRoYXQgbGVkIHRvIHRoYXQgaWRlYS4gIEl0J3Mgd29ya2luZywgYnV0IG5lZWRz IG1vcmUgdGhvdWdodC4NCg0KPj4gKiByZXRhaW5zIGV4aXN0aW5nIHN1bW1hcml6ZWQgaW5kZXgg SE9UIHVwZGF0ZSBsb2dpYw0KPiANCj4gR3JlYXQsIHRoYW5rcyENCj4gDQo+IEtpbmQgcmVnYXJk cywNCj4gDQo+IE1hdHRoaWFzIHZhbiBkZSBNZWVudA0KPiBOZW9uIChodHRwczovL25lb24udGVj aCkNCg0KSSBtaWdodCB3aWRlbiB0aGlzIHBhdGNoIGEgYml0IHRvIGluY2x1ZGUgc3VwcG9ydCBm b3IgdGVzdGluZyBlcXVhbGl0eSBvZiBpbmRleCB0dXBsZXMgdXNpbmcgY3VzdG9tIG9wZXJhdG9y cyB3aGVuIHRoZXkgZXhpc3QgZm9yIHRoZSBpbmRleC4gIEluIHRoZSB1c2UgY2FzZSBJJ20gc29s dmluZyBmb3Igd2UgdXNlIGEgY3VzdG9tIG9wZXJhdG9yIGZvciBlcXVhbGl0eSB0aGF0IGlzIG5v dCB0aGUgc2FtZSBhcyBhIG1lbWNtcCgpLiAgRG8geW91IGhhdmUgdGhvdWdodHMgb24gdGhhdD8g IEl0IG1heSBiZSBoYXJkIHRvIGFjY29tcGxpc2ggdGhpcyBhcyB0aGUgbm90aW9uIG9mIGFuIGVx dWFsaXR5IG9wZXJhdG9yIGlzIHNwZWNpZmljIHRvIHRoZSBpbmRleCBhY2Nlc3MgbWV0aG9kIGFu ZCBub3Qgd2VsbC1kZWZpbmVkIG91dHNpZGUgdGhhdCBBRkFJQ1QuICBJZiB0aGF0J3MgdGhlIGNh c2UgSSdkIGhhdmUgdG8gYXVnbWVudCB0aGUgZGVmaW5pdGlvbiBvZiBhbiBpbmRleCBhY2Nlc3Mg bWV0aG9kIHRvIHByb3ZpZGUgdGhhdCBpbmZvcm1hdGlvbi4NCg0KLWdyZWcNCg0K