| From: | tgl(at)postgresql(dot)org (Tom Lane) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Improve pull_up_subqueries logic so that it doesn't insert |
| Date: | 2009-04-28 21:31:16 |
| Message-ID: | 20090428213116.99D8E75407C@cvs.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | User Jbcooley | 2009-04-29 03:24:38 | npgsql - Npgsql2: #1010599 - update xml docs (fix typo in Clone) Thanks |
| Previous Message | User Bmomjian | 2009-04-28 20:21:05 | pg-migrator - src: Improve error checking, make sure binary was compiled |