On Mon, 25 Aug 2003, Pedro Alves wrote:
> The querys below are exactly the same but refer to different months.
> One case uses indexes, the other doesn't.
>
> Is there anything I can do? Increasing index mem size?
Run "vacuum analyze". The planner seems to think that one of the queries
returns 313 rows while the other returns 2388 rows.
To me that looks like the statistics need to be updated using vacuum
analyze.
Also, explain analyze gives a little more information and is better to
run then just explain.
--
/Dennis