Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Improve pull_up_subqueries logic so that it doesn't insert - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Improve pull_up_subqueries logic so that it doesn't insert
Date
Msg-id 20090428213116.99D8E75407C@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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)

pgsql-committers by date:

Previous
From: bmomjian@pgfoundry.org (User Bmomjian)
Date:
Subject: pg-migrator - src: Improve error checking, make sure binary was compiled
Next
From: heikki@postgresql.org (Heikki Linnakangas)
Date:
Subject: pgsql: Add check_keyword.pl script to perform some basic sanity checks