Other version of my problem:
If WHERE contains used_from=now() ::date, then query can use index(es).
If WHERE contains "<=" or "<" or ">", then query not use indexes.
I'm checking the multicolumn indexes+btree:
On the postgresql page:
http://www.postgresql.org/docs/8.3/i...lticolumn.html
contains: "Currently, only the B-tree and GiST index...
vaxx
Last Activity: Aug 22 '08, 05:48 PM
Joined: Aug 22 '08
Location:
-
select not using index
Hello,
My name is Mihaly Fazekas.
Sorry, my english is not good.
I have a query:
telefon=# EXPLAIN SELECT * FROM ext.ext_unit_hi er WHERE now()::date BETWEEN used_from AND used_to;
QUERY PLAN
-------------------------------------------------------------------------
Seq Scan on ext_unit_hier (cost=0.00..242 .58 rows=5808 width=36)
Filter: (((now())::date...
No activity results to display
Leave a comment: