Thread: pgsql: Improve pull_up_subqueries logic so that it doesn't insert

pgsql: Improve pull_up_subqueries logic so that it doesn't insert

From

tgl@postgresql.org (Tom Lane)

Date:

28 April 2009, 21:31:20

Log Message:
-----------
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.

Modified Files:
--------------
    pgsql/src/backend/optimizer/plan:
        planner.c (r1.254 -> r1.255)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c?r1=1.254&r2=1.255)
    pgsql/src/backend/optimizer/prep:
        prepjointree.c (r1.64 -> r1.65)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/prep/prepjointree.c?r1=1.64&r2=1.65)
    pgsql/src/include/optimizer:
        prep.h (r1.64 -> r1.65)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/prep.h?r1=1.64&r2=1.65)