Re: Proposal: Better query optimization for "NOT IN" clause

2019-09-23 Thread legrand legrand
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 "

Proposal: Better query optimization for "NOT IN" clause

2019-09-23 Thread John Bester
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