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

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

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Create the planner mechanism for optimizing simple MIN and MAX
Date: 2005-04-11 23:06:57
Message-ID: 20050411230657.8ACCF52A66@svr1.postgresql.org (view raw or flat)
Thread:
Lists: 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 by date

Next:From: User AglioDate: 2005-04-12 01:20:59
Subject: newsysviews - newsysview: Partial implementation of pg_users added for
Previous:From: User JwpDate: 2005-04-11 21:49:24
Subject: python - web: Add CVS Web interface links to the project description

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group