git.postgresql.org Git - users/bernd/postgres.git/commit

projects / users / bernd / postgres.git / commit

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	52de7f68778c04ec538375734dd29f5175d7b5cb
tree	6258cc7c99930a518c394f29e686083ec30325b8	tree
parent	35cc869f30695eccb36b8fe8653107cf8f3e4034	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

Bernd Helmle's repository

RSS Atom