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

projects / postgresql.git / commit

summary | shortlog | log | commit | commitdiff | tree
(parent: c3294f1) | patch

author	Tom Lane <tgl@sss.pgh.pa.us>
	Mon, 11 Apr 2005 23:06:57 +0000 (23:06 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Mon, 11 Apr 2005 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.