git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Create the planner mechanism for optimizing simple MIN and MAX queries

author Tom Lane <tgl@sss.pgh.pa.us>

2005年4月11日 23:06:57 +0000 (23:06 +0000)

committer Tom Lane <tgl@sss.pgh.pa.us>

2005年4月11日 23:06:57 +0000 (23:06 +0000)

commit addc42c339208d6a7a1d652fbf388e8aea7f80b9

tree e349d31f2ae1006ed4078b811dae8d842e00d969 tree

parent c3294f1cbfe02293b4a7c6b2e58ca4c09a7e541f commit | diff

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.

14 files changed:

src/backend/optimizer/path/indxpath.c diff | blob | blame | history

src/backend/optimizer/plan/Makefile diff | blob | blame | history

src/backend/optimizer/plan/planagg.c [new file with mode: 0644] blob

src/backend/optimizer/plan/planner.c diff | blob | blame | history

src/backend/optimizer/plan/subselect.c diff | blob | blame | history

src/backend/utils/cache/lsyscache.c diff | blob | blame | history

src/include/optimizer/paths.h diff | blob | blame | history

src/include/optimizer/planmain.h diff | blob | blame | history

src/include/optimizer/subselect.h diff | blob | blame | history

src/include/utils/lsyscache.h diff | blob | blame | history

src/test/regress/expected/aggregates.out diff | blob | blame | history

src/test/regress/expected/create_index.out diff | blob | blame | history

src/test/regress/sql/aggregates.sql diff | blob | blame | history

src/test/regress/sql/create_index.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom