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 |
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 |