Hello,
Just for information there are some works regarding how to include this in
core,
that may interest you ;o)
see "NOT IN subquery optimization"
https://www.postgresql.org/message-id/flat/1550706289606-0.post%40n3.nabble.com
commitfest entry: https://commitfest.postgresql.org/24/2023/
and "
One-line Summary:
Better query optimization for "NOT IN" clause
Business Use-case:
Using x NOT IN (SELECT y FROM target) on extremely large tables can
be done very fast. This
might be necessary in order to introduce foreign keys where old
systems re