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 1w5Rq0-003GBG-11 for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Mar 2026 17:16:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5Rpy-00FRVH-2V for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Mar 2026 17:16:11 +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 1w5Rpy-00FRV7-1X for pgsql-hackers@lists.postgresql.org; Wed, 25 Mar 2026 17:16:10 +0000 Received: from mail-ot1-x332.google.com ([2607:f8b0:4864:20::332]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w5Rpx-000000010E9-0PHR for pgsql-hackers@postgresql.org; Wed, 25 Mar 2026 17:16:10 +0000 Received: by mail-ot1-x332.google.com with SMTP id 46e09a7af769-7d7eb85fb81so37814a34.0 for ; Wed, 25 Mar 2026 10:16:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774458968; x=1775063768; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=rrx+KRvp7HM5KDrCq4sGk/SN1DY8RrJI83Pf2/QUJlo=; b=Lcur2B61S3B1+iXZAiMfBuOESbcTw+Hlt+dV7gqzt5EP6FXOWctu9LwUXTbSSPGP8m kFKawldGOMLJit26xAW03kZI1lubPzovtTuLDZ7t1Tq4Kcxm2o3eoDdTKk06fuDK6OpZ Oh0Ba8dN632ywF4QL3/SgV0OZ2SyBBh25UfaVqRfqBuuLTqmKBCJNn/xBiIiNcKvMdUa ef5pe5dscdhdh0h4WKKnWCMeIB7aA3B23tK/1WDoln5DMQi5k7KHugz4R8jgICkIrZQK qMaTj9Rk6EtmxS9jACvx+5qOtks2NFnpeBu8F2fXTYhBB7tYozIE4pyCVTNCh3hucQcU kstQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774458968; x=1775063768; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=rrx+KRvp7HM5KDrCq4sGk/SN1DY8RrJI83Pf2/QUJlo=; b=CWoDQiP8OMaK3U8MAL6OC7pAYP9zOeUBCawlX0G4Mi9kcHtrmXsWCO19kfS1r5wseB +/wk3nJ1tdnbCRGr5a8vZHEZTx7BCc99yqUQRst923L95v3pme4I+HXDVowCu/yNmMiY Ohe88KQOXvx8XxbPnxQfbp4S5UsOeCCDUpLdCR5FZJiHjKX1ZM3WWL9uxMgM6CcGYX5C bov/kL2QvsX09eKTL9OOJof1QOA2Uh4rPLkkSpbPUe0PsKrO0Ps7h1o3CL+r61ge9lxG LcqswegLjS3LPHYkGnAvZY0uFq0PlWispBjILsppKjWIq2y5MLSmPH1vK0Qwjv8zPsWR aVxA== X-Forwarded-Encrypted: i=1; AJvYcCWOjcLC33c2PI2xWq7WXamLqYrwPY4h2kgBOjVjz0wQEhsJvO3ZSEnmhHnRsErx3+ZAis1EDgIo4nSc/N8e@postgresql.org X-Gm-Message-State: AOJu0YysqdfGoJz5nYa1UZVlU5NDTtRtmqo7FfdwBzTHdj1gC916Fepd p2NpNwRw+JI2aWVE7NlnnY3N/PAIa7iQxVFKXFAZqiPcSlybZ34xEP9H X-Gm-Gg: ATEYQzxeULS7SeYFVo0JWkXjZHS3+DeBBqSy0aoeyHY3sUw59xCNgQChNRYwBhk7cRn cxUD7jriLLXEBE9TSvcsTrts5dXkNiFkkzagFGfttGIsP2MTzmtNDwt5EX24wsHpeBKY54mjIaP BEhWl6dzUtRpcUSJHq36RajcL9NrKLZ6xCA5ZfauMgJC6mmk2RbAztuB/7Ou0RzTzNJ0Wn/1TrS OeEXh0HyE/sjZDgnlqYFWdYP8EDI1Vcy2WcWp1gdSAOuDVNxDgfs4P7F5TAeHYTUq80QYqmmK1B G4/Neb5GqVXQc6F0ZTEi+EmQ9SpunigVP9gAzVoteJIF2ForwHpHud7YGXdkeGw5tQAnW3UdWM2 LR621SXjQxKswCOQVr43sD7CzVlqQSlJuEuhC/GL81MhSuSdBsYHFqNaKL9pZOsVVh4j/N6TOAr Mbuq+8dpzjZpdnugcpowCSzM34gDQ+JzJ6bFcy3l3mrsVG243YFq+bNPRMopRNaiIRLL0Vh2huc MfTFR4n5U4DlOLoM4ViKQ== X-Received: by 2002:a05:6830:82e7:b0:7d7:cba0:8b75 with SMTP id 46e09a7af769-7d9d68b2e7emr2576059a34.32.1774458968339; Wed, 25 Mar 2026 10:16:08 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 46e09a7af769-7d9e701545bsm201843a34.11.2026.03.25.10.16.07 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 25 Mar 2026 10:16:07 -0700 (PDT) Date: Wed, 25 Mar 2026 12:16:05 -0500 From: Nathan Bossart To: Greg Burd Cc: Jeff Davis , pgsql-hackers Subject: Re: Expanding HOT updates for expression and partial indexes Message-ID: References: <7b8681a578b5fe77103948eeb7b5cdd80fabad5d.camel@j-davis.com> <4f48f75d-4f2a-4240-b66d-597517796e02@app.fastmail.com> <3fba3f5671eddb221ba38f5a12acbe7cad27edf3.camel@j-davis.com> <427bfbda-c901-49e4-b725-8ddc41bec23d@app.fastmail.com> <887b1ee62794553a95c3578fcdc0cc1831e68b27.camel@j-davis.com> <4040d3a4-01c2-4f24-9025-57cfc19aea57@app.fastmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4040d3a4-01c2-4f24-9025-57cfc19aea57@app.fastmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I just spoke to Greg off-list and wanted to share my current thoughts on the list as well. In short, while we feel that the patch is in decent shape and seems to be performance neutral (or maybe even positive in some cases), it obviously doesn't accomplish $subject, and only a couple of folks have looked at it in depth. Furthermore, if this patch was committed and someone did find a problem, it'd be hard to justify anything except a revert. So, it's probably better to keep working on the full patch set and try to get $subject committed much earlier in the development cycle. If someone thinks that we should seriously consider committing this for v19, please let us know. -- nathan