Joachim Wieland <[EMAIL PROTECTED]> writes: > On Sat, May 26, 2007 at 11:40:52AM +0100, Heikki Linnakangas wrote: >> Or maybe some non-default values in postgresql.conf? Like random_page_cost?
> No, I use what initdb creates: Curiouser and curiouser. You still get the indexscan as preferred if you EXPLAIN the query after the regression tests complete, right? Could you step through cost_seqscan and see how it's arriving at such a high value? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate