pgsql: Simplify LATERAL-related calculations within add_paths_to_joinre
От | Tom Lane |
---|---|
Тема | pgsql: Simplify LATERAL-related calculations within add_paths_to_joinre |
Дата | |
Msg-id | E1a6oZU-0001GJ-V3@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Simplify LATERAL-related calculations within add_paths_to_joinrel(). While convincing myself that commit 7e19db0c09719d79 would solve both of the problems recently reported by Andreas Seltenreich, I realized that add_paths_to_joinrel's handling of LATERAL restrictions could be made noticeably simpler and faster if we were to retain the minimum possible parameterization for each joinrel (that is, the set of relids supplying unsatisfied lateral references in it). We already retain that for baserels, in RelOptInfo.lateral_relids, so we can use that field for joinrels too. This is a back-port of commit edca44b1525b3d591263d032dc4fe500ea771e0e. I originally intended not to back-patch that, but additional hacking in this area turns out to be needed, making it necessary not optional to compute lateral_relids for joinrels. In preparation for those fixes, sync the relevant code with HEAD as much as practical. (I did not risk rearranging fields of RelOptInfo in released branches, however.) Branch ------ REL9_5_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/c3c5c02881d47b3bf8d9e1e1e3460ef348863035 Modified Files -------------- src/backend/nodes/outfuncs.c | 2 +- src/backend/optimizer/path/joinpath.c | 73 +++++++-------------------------- src/backend/optimizer/util/relnode.c | 4 +- src/include/nodes/relation.h | 12 +++--- 4 files changed, 24 insertions(+), 67 deletions(-)
В списке pgsql-committers по дате отправления: