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 1thSUm-002gUx-0p for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Feb 2025 12:02:36 +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 1thSUk-000f1s-B9 for pgsql-hackers@arkaria.postgresql.org; Mon, 10 Feb 2025 12:02:34 +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 1thSUj-000f1i-UO for pgsql-hackers@lists.postgresql.org; Mon, 10 Feb 2025 12:02:34 +0000 Received: from smtp-fw-80008.amazon.com ([99.78.197.219]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1thSUh-0001Iy-2l for pgsql-hackers@postgresql.org; Mon, 10 Feb 2025 12:02:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1739188951; x=1770724951; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=jcoQlYiRmtYyIwPiClYqFQa2tOSbMlyepiJVmR9DkHI=; b=rGBQvjNnGqQQTGCuv/FCRgaS4ZYLxMn2TprLE0He1UkzVsNrjT9B00Sc DTJUDnV6yO9ql1gShe6JcDq6vQSicomtO5GRABafeblfKeK/fAW3qoe1f TYpow3N7eHCg94x6bOmAvORbfnSZjakbofKIBrweKy445rXlijuRmhY+Z w=; X-IronPort-AV: E=Sophos;i="6.13,274,1732579200"; d="scan'208";a="168384414" 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-vlan3.amazon.com (HELO smtpout.prod.us-east-1.prod.farcaster.email.amazon.dev) ([10.25.36.214]) by smtp-border-fw-80008.pdx80.corp.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 10 Feb 2025 12:02:28 +0000 Received: from EX19MTAUEC001.ant.amazon.com [10.0.29.78:29327] by smtpin.naws.us-east-1.prod.farcaster.email.amazon.dev [10.0.5.114:2525] with esmtp (Farcaster) id 55024d70-f5ce-40c4-81d9-449bb76e5004; Mon, 10 Feb 2025 12:02:28 +0000 (UTC) X-Farcaster-Flow-ID: 55024d70-f5ce-40c4-81d9-449bb76e5004 Received: from EX19D018UEC001.ant.amazon.com (10.252.135.153) by EX19MTAUEC001.ant.amazon.com (10.252.135.222) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1258.39; Mon, 10 Feb 2025 12:02:28 +0000 Received: from EX19D018UEC003.ant.amazon.com (10.252.135.218) by EX19D018UEC001.ant.amazon.com (10.252.135.153) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1544.14; Mon, 10 Feb 2025 12:02:28 +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; Mon, 10 Feb 2025 12:02:28 +0000 From: "Burd, Greg" To: Laurenz Albe CC: "pgsql-hackers@postgresql.org" Thread-Index: AQHbeOXmdtbUqSdSp0SlUCqonUkHPbM+ggyAgAHzaoA= Date: Mon, 10 Feb 2025 12:02:27 +0000 Message-ID: References: <78574B24-BE0A-42C5-8075-3FA9FA63B8FC@amazon.com> <0a47ce53fa635787d36325b5ad7bac94cdca4246.camel@cybertec.at> In-Reply-To: <0a47ce53fa635787d36325b5ad7bac94cdca4246.camel@cybertec.at> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.106.178.24] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gRmViIDksIDIwMjUsIGF0IDE6MTTigK9BTSwgTGF1cmVueiBBbGJlIDxsYXVyZW56LmFsYmVA Y3liZXJ0ZWMuYXQ+IHdyb3RlOg0KPiANCj4gSSB0aGluayB0aGF0IHRoZSBnb2FsIG9mIHRoaXMg cGF0Y2ggaXMgaW50ZXJlc3RpbmcgYW5kIGRlc2lyYWJsZS4NCg0KVGhhbmtzIGZvciB0YWtpbmcg YSBsb29rIGF0IGl0LiBXaGljaCB2ZXJzaW9uIGRpZCB5b3UgcHJlZmVyLCB2MyBvciB2ND8NCg0K PiBUaGUgZ3JlYXRlc3QgY29uY2VybiBmb3IgbWUgaXMgdGhlIHBlcmZvcm1hbmNlIGltcGFjdC4N Cg0KQWdyZWVkLCBJ4oCZbSBzdGlsbCBsb29raW5nIGZvciB3YXlzIHRvIG1pbmltaXplIGl0IChz dWdnZXN0aW9ucyB3ZWxjb21lKS4NCg0KPiBJIHRoaW5rIHRoYXQgYSBzd2l0Y2ggaXMgd2FycmFu dGVkLCBidXQgSSBhbSBub3Qgc3VyZSBpZiBpdCBzaG91bGQgYmUgYSBHVUMuDQo+IFdvdWxkbid0 IGl0IGJlIGJldHRlciB0byBoYXZlIGEgcmVsb3B0aW9uLCBzbyB0aGF0IHRoaXMgY2FuIGJlIGNv bmZpZ3VyZWQgcGVyIHRhYmxlPw0KDQpJIGNhbiByZW1vdmUgdGhlIEdVQyBpbiBmYXZvciBvZiBh IHJlbG9wdGlvbiwgdGhhdCBtYWtlcyBzZW5zZSB0byBtZS4NCg0KPiBZb3VycywNCj4gTGF1cmVu eiBBbGJlDQoNCmJlc3QsDQoNCi1ncmVn