Ron Arts <ron(dot)arts(at)neonova(dot)nl> writes:
> A. Kretschmer schreef:
>> You can try to force an index-scan by disabling the seq-scan (set
>> enable_seqscan='no';) and re-run the query.
> That does force it to use the index, but doesn't speed up my query.
IOW, the planner chose the right plan. Don't complain...
I think the real answer here is that the planner thinks the table
is too small to bother with an index. If you load up a non-toy
amount of data you might get a different plan.
regards, tom lane