yes, forgot to mention that the hole database is "VACUUM ANALYZE" after
the index creation, couple of times.
and also my message was incomplete and the problem is in the omission.
the order clause was not mentioned, witch I think is causing the
"problem", by adding both columns in the order cl
[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:
> I have two indexes on a table on cols col1 and col2, the table has ~10M
> rows on pg v8.1.4
>
> when I use "where col1 = val1" the query is fast and returns 0 rows
> when I use "where col2 > val2" the query is slow and returns ~1M rows
>
> in both
