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

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposal: Better query optimization for "NOT IN" clause
Date: 2019-09-23 19:25:51
Message-ID: 1569266751325-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 "Converting NOT IN to anti-joins during planning"
https://www.postgresql.org/message-id/flat/CAKJS1f82pqjqe3WT9_xREmXyG20aOkHc-XqkKZG_yMA7JVJ3Tw%40mail.gmail.com

commitfest entry: https://commitfest.postgresql.org/24/2020/

Regards
PAscal

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2019-09-23 19:29:02 Re: JSONPATH documentation
Previous Message Dmitry Dolgov 2019-09-23 19:15:24 Re: Cache lookup errors with functions manipulation object addresses