Feedback-ID: ie0a040ee:Fastmail
Message-ID: <ff48df7b-8b82-4cf4-a340-668dadeff88f@eisentraut.org>
Date: Mon, 16 Feb 2026 20:52:42 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Inval reliability, especially for inplace updates
To: Noah Misch <noah@leadboat.com>, Mark Dilger <mark.dilger@enterprisedb.com>
Cc: Nitin Motiani <nitinmotiani@google.com>,
 Andres Freund <andres@anarazel.de>, pgsql-hackers@postgresql.org
References: <20240831010711.67.nmisch@google.com>
 <20240930193350.04.nmisch@google.com>
 <CAH5HC9508Xvz4BVca8OCoDOv7pgHqAf85EqZkWMZ_Q2hAkebzg@mail.gmail.com>
 <20241013004511.9c.nmisch@google.com>
 <CAH5HC94r2ZKy_MhNaPUjn7NHkOFgbyBAgV2jaYSRt35BNWuOAA@mail.gmail.com>
 <CAH5HC95rn4gON8zNrFXFY-Cn4z0NZuDU_1TDwKnafX_25_C0UA@mail.gmail.com>
 <20241024025357.a8.nmisch@google.com>
 <CAHgHdKsQYHz4XDOtUwNSn+JRv1kyatLiNYLHu4Y9V_xR4Y5kpA@mail.gmail.com>
 <20260121174720.71.noahmisch@microsoft.com>
 <CAHgHdKvTv6knvzmtumdzAqF9_PykaUc6b-6c80VpMZEV0UuyZQ@mail.gmail.com>
 <20260122174250.bf@rfd.leadboat.com>
Content-Language: en-US
From: Peter Eisentraut <peter@eisentraut.org>
In-Reply-To: <20260122174250.bf@rfd.leadboat.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/ff48df7b-8b82-4cf4-a340-668dadeff88f%40eisentraut.org>
Precedence: bulk

On 22.01.26 18:42, Noah Misch wrote:
> On Thu, Jan 22, 2026 at 07:53:21AM -0800, Mark Dilger wrote:
>> On Wed, Jan 21, 2026 at 9:47 AM Noah Misch <noah@leadboat.com> wrote:
>>> Based on your experience, I probably should encourage packagers to do an
>>> early check of the packages they build, especially if they build tableam
>>> modules not found in PGXN.  How do you see it?
>>
>> I don't know what you mean by "early".  18.2 hasn't stamped yet.  18.1
>> doesn't have the change.  So, I'd say that I'm building pretty early, and I
>> noticed the change will be coming in 18.2.
> 
> I'll probably say:
> 
>    If you've tested your packaging builds against REL_17_STABLE and
>    REL_18_STABLE since 2025-12-16 *or* you package only modules present in
>    PGXN, you can stop reading.
> 
>    Mark Dilger reported non-PGXN tableam modules that needed changes to cope
>    with back-patched signature changes in functions
>    CacheInvalidateHeapTupleInplace() (commit 06b030e) and
>    PrepareToInvalidateCacheTuple() (commit 2e58802).  Consider trying a rebuild
>    against REL_17_STABLE and REL_18_STABLE now, so you learn about any similar
>    need for changes in your modules.

It has been requested to revert these, because they are an ABI and API 
break, and they are unnecessary in the backbranches.  Could we do this 
please?

>> Oh, I don't mean to question the overall purpose of the patch.  I was
>> questioning whether it needed to have breaking changes which are mere "code
>> cleanup".  The change to CacheInvalidateHeapTupleInplace to remove the
>> unused third argument seemed inappropriate for backpatching, so I spoke up
>> before 18.2 is stamped.  Doing this one piece of code cleanup in the back
>> branches will cause a lot of packaging pain for no real benefit.
> 
> Is the source code for one of these modules published?  I'm not picturing how
> a module could need a CacheInvalidateHeapTupleInplace() call, so your code may
> illuminate that for me.
> 
> If you upload one of these modules to PGXN, my scans before future ABI breaks
> will find its calls and will block avoidable ABI breaks like the
> CacheInvalidateHeapTupleInplace() one.

Since the heap AM calls this, it doesn't seem surprising that another 
table AM would call it too.