From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Richard Guo <guofenglinux(at)gmail(dot)com> |
Cc: | Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "Finnerty, Jim" <jfinnert(at)amazon(dot)com> |
Subject: | Re: Making Vars outer-join aware |
Date: | 2022-11-16 22:02:41 |
Message-ID: | 1688317.1668636161@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Richard Guo <guofenglinux(at)gmail(dot)com> writes:
> BTW, inner_join_rels can contain base Relids and OJ Relids. Maybe we
> can revise the comments a bit for it atop deconstruct_recurse and
> make_outerjoininfo. The same for the comments of qualscope, ojscope and
> outerjoin_nonnullable atop distribute_qual_to_rels.
Yeah. I had an XXX comment about whether or not it was okay to
include OJs in inner_join_rels. I took a second look and decided it's
fine, so I removed the XXX and updated these comments.
> The README mentions restriction_is_computable_at(), I think it should be
> clause_is_computable_at().
Right. I think when I wrote that I was imagining that there'd be a
wrapper function specifically concerned with RestrictInfos, but in the
event it didn't seem useful. There's only one place that uses this,
namely subbuild_joinrel_restrictlist.
The cfbot is about to start complaining that this patchset doesn't apply
over e9e26b5e7, so here's a rebase.
regards, tom lane
Attachment | Content-Type | Size |
---|---|---|
v7-0000-add-overview-documentation.patch | text/x-diff | 25.5 KB |
v7-0001-add-nullingrels-fields.patch | text/x-diff | 16.9 KB |
v7-0002-label-Var-nullability-in-parser.patch | text/x-diff | 22.0 KB |
v7-0003-cope-with-nullability-in-planner.patch | text/x-diff | 198.1 KB |
v7-0004-add-rinfo-serial-numbers.patch | text/x-diff | 26.8 KB |
v7-0005-fix-flatten_join_alias_vars.patch | text/x-diff | 14.4 KB |
v7-0006-fix-FDWs.patch | text/x-diff | 10.1 KB |
v7-0007-avoid-using-nullable_relids.patch | text/x-diff | 9.8 KB |
v7-0008-remove-nullable_relids.patch | text/x-diff | 40.9 KB |
v7-0009-simplify-dummy-join-clauses.patch | text/x-diff | 13.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2022-11-16 22:14:07 | Re: Allow single table VACUUM in transaction block |
Previous Message | Greg Stark | 2022-11-16 21:52:16 | Re: PATCH: Using BRIN indexes for sorted output |