Re: database performance and query performance question

Shea,Dan [CIS] kirjutas N, 22.01.2004 kell 22:35:
> Something that I do not understand is why if you use a valid_time =
> '2004-01-22 00:00:00' the query will use the index but if you do a
> valid_time >  '2004-01-22 00:00:00' it does not use the index?

It probably can't tell if > is selective enough to justify using index.

Together with "limit 10" it may be.

You could try

explain analyze select * from forecastelement where valid_time between
'2004-01-22'::date and '2004-01-22'::date limit 10;

to see if this is considered good enough.

--------------
Hannu