Jeroen van Iddekinge <iddekingej(at)lycos(dot)com> writes:
>> You could tweak with several settings to get it to do an index scan
>> earlier, but these would probably break other queries. You don't need to
>> tune for 100 rows, morelike 100k or 100M.
> Which settings shoud I change for this?
I'd agree with John's response: if you change any settings based on just
this one test case, you're a fool. But usually random_page_cost is the
best knob to twiddle if you wish to encourage indexscans.
regards, tom lane