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 1w2BlR-0004K7-2e for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2026 17:30:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2BlP-00BZEC-33 for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2026 17:30:00 +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 1w2BlP-00BZDx-2A for pgsql-hackers@lists.postgresql.org; Mon, 16 Mar 2026 17:30:00 +0000 Received: from mail-oi1-x232.google.com ([2607:f8b0:4864:20::232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2BlN-000000002wf-18Yj for pgsql-hackers@postgresql.org; Mon, 16 Mar 2026 17:29:59 +0000 Received: by mail-oi1-x232.google.com with SMTP id 5614622812f47-467166cb638so1720429b6e.2 for ; Mon, 16 Mar 2026 10:29:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773682198; x=1774286998; 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=FMFQoaGNTCNzfWdzZQl2u2Al5tq3ndUbYbJgoMED1Ko=; b=eW71vFOPT03YxR43+1wOdT1G0usIzF7MDfQiHChKRmXbugdQDrUOsiRosvzlIim2MB xRAUpaJBi62kuGe90dO5mLHMMiNEyuI25tZKDgwMcBmlCJGDOT1AlOIl0Yq91KsMvrYv wV9e1jwxg4WgFtdGfDAmYcQ3NeZaJ5DzOxF3Q49EpTqwvDW9gZsSw6bif3/d2QgEA2y0 vigYiawXbVPZQamdduxpeh0hgEFP5jJnLc5ODsgpJevKTJni62a0TIFHXU5AKTf6W7Ex eZ53b73K/nUiR9v3omhM1EDAqCnF+WkG4E1sknD3M10p1vv1x43XXtvZoOvc7NBMApxn yOAQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773682198; x=1774286998; 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=FMFQoaGNTCNzfWdzZQl2u2Al5tq3ndUbYbJgoMED1Ko=; b=YHmIBkBJjg6Vh2Tk9s95xMqg1KAGfmFKUgBYEkkbpWhiJMaq9Z1+rMj/RF8iY1floK xb3C5289DtHDvVh6I9nS7g0lR8nggLEHryU07FOgBbwvGq4KdSfH5GX69rsWRqsQck3U AdKw5CAtKIj5p80ukRoVhiz6Ihk2eWpIWluPwijP02FRkPSnzBuUyaOnoAf1uw+A5qwe f2pnsNspWBw20UvaRwoFhK11GgxDgFQ29cdzc7wi2Hy6ljg1IK+Y8WOlHRBLwgPBcjYH Lwnmz6DLsNCU8I8gQy4UEekQOONDNPb6aSfksu48hJfrKnVsEbVqMcYaKYb2rKDSkR6c Rbfg== X-Forwarded-Encrypted: i=1; AJvYcCVfJ7bULQriKKeCwhL8Yb1V4wFPikoDLFpQqDJo9m9XRIX8suQkQTmfnUpi8osz30x1kvzqQrHk2vH1Y/wV@postgresql.org X-Gm-Message-State: AOJu0YzgvN77zSOo80jiDynHrcrXkdHEZouBEeVeW1uNFl8dqrd5mc2W t7/aGF27f2wNJNfiP4nEsH1JLMt8yohdzj9no05DSOMWWuux5vu8T0YM X-Gm-Gg: ATEYQzwjMNowBABIath2vdCaIszWxMDBgAJOS3UfI64Hcq4zWEae2oYZWg/edYFkkgu bleYSsDmmoMMX+nQLrY+juyl0p6Spw/4of/L/ICAKHgyzzcqddxkf0JDqLyUb/RuloWu0K0CsZj ZNQZCVjXvD7OKuYLireVxDP9fRFS2bsruD1vzC9qfRz6obD2hou3MhB60mqsIK4dpsXZp3E3zGJ T3VitqjX0ocNpn+HyiZdull6ofBtm2VGDYExnbfArXtXRhLIyxZ64ZmRHzJAvEKHYAWtNQyvNoW C62xZDj2M8IjTNikNJ4yYS6014A7xzR7oh6W2cRYGBW2kqTCl5gdpCGEo1CnkW0iJwG8rV+meBY jJ5YFNSXpEiaB+exvvKM3FwYj3tfFpBfyYgUOwY6V6gX/5MYaWoM09vs2sSgu2nXbmm+EMFY4Wq zjtJglQLQ8FDwO6MklnQEkgeymVexu/hsJvbpF4jVOH3cLm9QbmGT/eJQcmxqbiAGS8VwZISXxP 7ggabDePebJekxzKTcboQ== X-Received: by 2002:a05:6808:16ab:b0:45c:94e7:ba96 with SMTP id 5614622812f47-467572f3f36mr6897830b6e.38.1773682198145; Mon, 16 Mar 2026 10:29:58 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 5614622812f47-46734123939sm9870447b6e.3.2026.03.16.10.29.57 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 16 Mar 2026 10:29:57 -0700 (PDT) Date: Mon, 16 Mar 2026 12:29:55 -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: <9bb9bdd6-e1fe-48fe-837d-4d0289396f1c@app.fastmail.com> <872b875c-0aa4-4269-9c84-532227b32361@app.fastmail.com> <91f4dbe2-21ed-49f3-bebe-270f9bbec9d5@app.fastmail.com> <811d6f42e5481935943556b692859aae9146d4c9.camel@j-davis.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Mar 16, 2026 at 12:23:04PM -0400, Greg Burd wrote: > On Sun, Mar 15, 2026, at 5:11 PM, Jeff Davis wrote: >> Why do extra work in ExecBRUpdateTriggers() to eliminate the false >> negative case if we don't rely on it anyway? If we do need to rely on >> it in subsequent patches, then we need to be sure, right? > > [...] > > What do we "need to be sure" of? That ExecGetAllUpdatedCols() not really > contains all attributes that its name implies? I think it now does that > after 0002, do you disagree? I'm admittedly still digging into the details, but the main question on my mind is whether there are other cases lurking that our in-tree tests aren't catching or that only exist in extensions. Will there be some sort of check or assertion to catch those? -- nathan