Pull up sublink of type 'NOT NOT (expr)'

From: Richard Guo <riguo(at)pivotal(dot)io>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Pull up sublink of type 'NOT NOT (expr)'
Date: 2018-10-17 08:14:31
Message-ID: CAN_9JTxpgxnTa_EPvmfuy6vogY0smQmYbEvbJhx=bD1iAjK5BQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

Currently for quals in the form of "NOT NOT (SubLink)", this SubLink would
not
be considered when pulling up sublinks. For instance:

gpadmin=# explain select * from a where NOT NOT (a.i in (select b.i from
b));
QUERY PLAN
-------------------------------------------------------------
Seq Scan on a (cost=51.50..85.62 rows=1005 width=8)
Filter: (hashed SubPlan 1)
SubPlan 1
-> Seq Scan on b (cost=0.00..44.00 rows=3000 width=4)
(4 rows)

Should we give it a chance, like the attached does?

Thanks
Richard

Attachment Content-Type Size
0001-Pull-up-sublink-of-type-NOT-NOT-expr.patch application/octet-stream 1.6 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Victor Wagner 2018-10-17 08:38:46 Perl 5.26 and windows build system
Previous Message Victor Wagner 2018-10-17 07:47:01 Building 64-bit postgres with GSS support on windows