Dmitry Panov <dmitry(at)tsu(dot)tula(dot)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