]> granicus.if.org Git - postgresql/commit
Skip opfamily check in eclass_matches_any_index() when the index isn't a
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 12 Sep 2008 14:56:13 +0000 (14:56 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 12 Sep 2008 14:56:13 +0000 (14:56 +0000)
commitbf0b6ac43c5d5eb7458e0aa4bf5f45c566f7c7d1
treeafd42cfd131dc94d557a3b05501aa99b6baa60f3
parentcdd08959788a38965bdef9501e04f1fac2f71f4c
Skip opfamily check in eclass_matches_any_index() when the index isn't a
btree.  We can't easily tell whether clauses generated from the equivalence
class could be used with such an index, so just assume that they might be.
This bit of over-optimization prevented use of non-btree indexes for nestloop
inner indexscans, in any case where the join uses an equality operator that
is also a btree operator --- which in particular is typically true for hash
indexes.  Noted while trying to test the current hash index patch.
src/backend/optimizer/path/indxpath.c