Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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


  • 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: Tue, 28 Apr 2009 21:31:16 +0000 (UTC)
  • Message-id: <20090428213116.99D8E75407C@cvs.postgresql.org> <text/plain>

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)



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group