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

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Improve pull_up_subqueries logic so that it doesn't insert
Дата
Msg-id 20090428213116.99D8E75407C@cvs.postgresql.org
обсуждение исходный текст
Список 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)

В списке pgsql-committers по дате отправления:

Предыдущее
От: bmomjian@pgfoundry.org (User Bmomjian)
Дата:
Сообщение: pg-migrator - src: Improve error checking, make sure binary was compiled
Следующее
От: heikki@postgresql.org (Heikki Linnakangas)
Дата:
Сообщение: pgsql: Add check_keyword.pl script to perform some basic sanity checks