• Tom Lane's avatar
    Skip opfamily check in eclass_matches_any_index() when the index isn't a · bf0b6ac4
    Tom Lane authored
    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.
    bf0b6ac4
indxpath.c 88 KB