Jeroen van Iddekinge <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to