Re: indices usage

Dmitry Panov <dmitry@tsu.tula.ru> writes:
> isp_leased=# explain select count(*) from traffic_stat where timestamp between timestamp('2001-12-18') and
timestamp('2001-12-19');

> The question is why it doesn't make use of traffic_stat_idx2?

Try '2001-12-19'::timestamp, instead, or use CAST if you want to conform
to the standard.  The function syntax is not considered a constant for
reasons I won't delve into here.

> I think cost estimation is wrong in this case.

Could easy be.  Do you want to try it with 7.2 beta?

            regards, tom lane