| 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: | Whole Thread | Raw Message | 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 |