pgsql: Skip opfamily check in eclass_matches_any_index() when the index

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Skip opfamily check in eclass_matches_any_index() when the index
Дата
Msg-id 20080912145619.AA38D7545A3@cvs.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
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.

Tags:
----
REL8_3_STABLE

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        indxpath.c (r1.227 -> r1.227.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c?r1=1.227&r2=1.227.2.1)

В списке pgsql-committers по дате отправления:

Предыдущее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Skip opfamily check in eclass_matches_any_index() when the index
Следующее
От: dpage@pgfoundry.org (Dave Page)
Дата:
Сообщение: stackbuilder - wizard: New icon