]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Change the planner to allow indexscan qualification clauses to use
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 13 Jun 2005 23:14:49 +0000 (23:14 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 13 Jun 2005 23:14:49 +0000 (23:14 +0000)
commitc186c93148fdfa5a39972331318eda5318ff5eba
tree31195d72e9b44d701eaa9018e498145f3d46f929
parent077811605e07212139c3df503fdaa081690635ca
Change the planner to allow indexscan qualification clauses to use
nonconsecutive columns of a multicolumn index, as per discussion around
mid-May (pghackers thread "Best way to scan on-disk bitmaps").  This
turns out to require only minimal changes in btree, and so far as I can
see none at all in GiST.  btcostestimate did need some work, but its
original assumption that index selectivity == heap selectivity was
quite bogus even before this.
12 files changed:
doc/src/sgml/catalogs.sgml
doc/src/sgml/indexam.sgml
src/backend/access/index/indexam.c
src/backend/access/nbtree/nbtsearch.c
src/backend/access/nbtree/nbtutils.c
src/backend/optimizer/path/indxpath.c
src/backend/optimizer/util/plancat.c
src/backend/utils/adt/selfuncs.c
src/include/access/genam.h
src/include/catalog/catversion.h
src/include/catalog/pg_am.h
src/include/nodes/relation.h