| From: | tgl(at)postgresql(dot)org (Tom Lane) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Skip opfamily check in eclass_matches_any_index() when the index |
| Date: | 2008-09-12 14:56:19 |
| Message-ID: | 20080912145619.AA38D7545A3@cvs.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2008-09-12 15:04:41 | stackbuilder - wizard: New icon |
| Previous Message | Tom Lane | 2008-09-12 14:56:13 | pgsql: Skip opfamily check in eclass_matches_any_index() when the index |