Re: Convert NOT IN sublinks to anti-joins when safe - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Convert NOT IN sublinks to anti-joins when safe
Date
Msg-id CAMbWs48YE2V9YhHWHP5seZ8fs2of7xcG1Vace7BQWsSvsQ2EjQ@mail.gmail.com
Whole thread Raw
In response to Re: Convert NOT IN sublinks to anti-joins when safe  (Japin Li <japinli@hotmail.com>)
Responses Re: Convert NOT IN sublinks to anti-joins when safe
List pgsql-hackers
On Thu, Mar 5, 2026 at 10:57 AM Japin Li <japinli@hotmail.com> wrote:
> Just a quick note: I think `foreach_ptr` is more appropriate here than `foreach`.

Agreed.

For homogeneous lists, it is better to use foreach_node so we get the
additional type-safety assertions in dev builds.  For heterogeneous
lists, we should use foreach_ptr.

Attached is an updated version of the patch that replaces foreach with
foreach_ptr or foreach_node accordingly.  Nothing else has changed.

I plan to do one more round of self-review on this.  Unless there are
any further thoughts or concerns, I'm hoping to commit this in a week
or two.  Please let me know if anyone spots anything else I might have
missed.

- Richard

Attachment

pgsql-hackers by date:

Previous
From: Alexandre Felipe
Date:
Subject: Re: index prefetching
Next
From: Tomas Vondra
Date:
Subject: Re: index prefetching