Scott Marlowe wrote:
>> random_page_cost = 1 # units are one sequential page
>> fetch
>
> Seldom if ever is it a good idea to bonk the planner on the head with
> random_page_cost=1. setting it to 1.2 ot 1.4 is low enough, but 1.4
> to 2.0 is more realistic.
Which is probably the reason why the planner thinks a seq scan is
faster than an index scan...
Jan
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
