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.
indxpath.c (r1.232 -> r1.233)
pgsql-committers by date
|Next:||From: Tom Lane||Date: 2008-09-12 14:56:19|
|Subject: pgsql: Skip opfamily check in eclass_matches_any_index() when the index |
|Previous:||From: Dave Page||Date: 2008-09-12 14:46:05|
|Subject: stackbuilder - wizard: New icon|