projects / users / heikki / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 636edd5) | patch
Improve pull_up_subqueries logic so that it doesn't insert unnecessary
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 28 Apr 2009 21:31:16 +0000 (21:31 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 28 Apr 2009 21:31:16 +0000 (21:31 +0000)
commitc59d8dd44d34ea617296b4a2d6e22fefc74593ed
tree786e89d2c217b9ed3628cfa09f61993101c48fd3tree
parent636edd553daafeaab775d0f4054ca02fa5240ad0commit | diff
Improve pull_up_subqueries logic so that it doesn't insert unnecessary
PlaceHolderVar nodes in join quals appearing in or below the lowest
outer join that could null the subquery being pulled up.  This improves
the planner's ability to recognize constant join quals, and probably
helps with detection of common sort keys (equivalence classes) as well.
src/backend/optimizer/plan/planner.c diff | blob | blame | history
src/backend/optimizer/prep/prepjointree.c diff | blob | blame | history
src/include/optimizer/prep.h diff | blob | blame | history
Heikki's random PostgreSQL patches