pgsql: Create the planner mechanism for optimizing simple MIN and MAX

Поиск
Список
Период
Сортировка
От tgl@svr1.postgresql.org (Tom Lane)
Тема pgsql: Create the planner mechanism for optimizing simple MIN and MAX
Дата
Msg-id 20050411230657.8ACCF52A66@svr1.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Create the planner mechanism for optimizing simple MIN and MAX queries
into indexscans on matching indexes.  For the moment, it only handles
int4 and text datatypes; next step is to add a column to pg_aggregate
so that all MIN/MAX aggregates can be handled.  Per my recent proposal.

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        indxpath.c (r1.172 -> r1.173)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c.diff?r1=1.172&r2=1.173)
    pgsql/src/backend/optimizer/plan:
        Makefile (r1.12 -> r1.13)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/Makefile.diff?r1=1.12&r2=1.13)
        planner.c (r1.183 -> r1.184)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c.diff?r1=1.183&r2=1.184)
        subselect.c (r1.95 -> r1.96)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/subselect.c.diff?r1=1.95&r2=1.96)
    pgsql/src/backend/utils/cache:
        lsyscache.c (r1.122 -> r1.123)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/lsyscache.c.diff?r1=1.122&r2=1.123)
    pgsql/src/include/optimizer:
        paths.h (r1.80 -> r1.81)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/paths.h.diff?r1=1.80&r2=1.81)
        planmain.h (r1.80 -> r1.81)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/planmain.h.diff?r1=1.80&r2=1.81)
        subselect.h (r1.23 -> r1.24)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/subselect.h.diff?r1=1.23&r2=1.24)
    pgsql/src/include/utils:
        lsyscache.h (r1.96 -> r1.97)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/lsyscache.h.diff?r1=1.96&r2=1.97)
    pgsql/src/test/regress/expected:
        aggregates.out (r1.11 -> r1.12)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/aggregates.out.diff?r1=1.11&r2=1.12)
        create_index.out (r1.14 -> r1.15)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/create_index.out.diff?r1=1.14&r2=1.15)
    pgsql/src/test/regress/sql:
        aggregates.sql (r1.9 -> r1.10)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/aggregates.sql.diff?r1=1.9&r2=1.10)
        create_index.sql (r1.13 -> r1.14)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/create_index.sql.diff?r1=1.13&r2=1.14)

Added Files:
-----------
    pgsql/src/backend/optimizer/plan:
        planagg.c (r1.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planagg.c?rev=1.1&content-type=text/x-cvsweb-markup)

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

Предыдущее
От: jwp@pgfoundry.org (User Jwp)
Дата:
Сообщение: python - web: Add CVS Web interface links to the project description
Следующее
От: aglio@pgfoundry.org (User Aglio)
Дата:
Сообщение: newsysviews - newsysview: Partial implementation of pg_users added for