| From: | Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | prerequisites of pull_up_sublinks |
| Date: | 2021-04-21 02:55:29 |
| Message-ID: | CAKU4AWrmgivKLsrxQtgcyfMkgCTRh-AbLfyawQUzgQQgr_PCUQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
I'm reading the pull_up_sublinks, and find the below comments.
* However, this optimization *only*
* works at the top level of WHERE or a JOIN/ON clause, because we cannot
* distinguish whether the ANY ought to return FALSE or NULL in cases
* involving NULL inputs. Also, in an outer join's ON clause we can only
* do this if the sublink is degenerate (ie, references only the nullable
* side of the join).
I tried to write some SQLs but still can't understand the above comments.
Any
help here?
--
Best Regards
Andy Fan (https://www.aliyun.com/)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2021-04-21 03:11:45 | Re: Tiny update to pg_stat_statements documentation |
| Previous Message | Michael Paquier | 2021-04-21 02:50:35 | Re: Is it worth to optimize VACUUM/ANALYZE by combining duplicate rel instances into single rel instance? |