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
In response to
pgsql-novice by date
|Next:||From: Ron Arts||Date: 2009-09-18 14:27:32|
|Subject: Re: Index not used in join.. (example included).|
|Previous:||From: Ron Arts||Date: 2009-09-18 13:15:15|
|Subject: Re: Index not used in join.. (example included)|