| From: | uwcssa <uwcssa(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | equivalence class not working? |
| Date: | 2006-01-16 21:19:59 |
| Message-ID: | f2f562510601161319k4b0201a9p8d93a649780df7f1@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
not sure if this is the right place to post...
I am using postgres 8.1. In indxpath.c, it says " Note: if Postgres tried
to optimize queries by forming equivalence
classes over equi-joined attributes (i.e., if it recognized that
aqualification such as "where
a.b=c.d and a.b=5" could make use of
an index on c.d), then we could use that equivalence class info here with
joininfo_list to do more complete tests for the usability
of a partial index. ..... XXX as of 7.1, equivalence class info *is*
available."
Now i have the following two queries on TPC-H, where there is an index built
on "o_totalprice".
explain select * from lineitem, orders where o_totalprice=l_extendedprice
and l_extendedprice<2000;
explain select * from lineitem, orders where o_totalprice=l_extendedprice
and l_extendedprice<2000 and o_totalprice<2000;
The second query uses the index while the first does not. It seems to me
that both queries are the same (the "o_totalprice<2000" in the second query
can be inferred). Is there something that needs to be tuned or ...?
thanks a lot!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-01-16 21:21:50 | Re: Anyone see a need for BTItem/HashItem? |
| Previous Message | David Fetter | 2006-01-16 21:08:19 | Re: Anyone see a need for BTItem/HashItem? |