Re: sequence scan on PK

Jeroen van Iddekinge <iddekingej@lycos.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