"Dann Corbit" <[EMAIL PROTECTED]> writes: > Yikes! Five times slower! But then I took Tom's incredibly helpful > suggestion to disable the sequential scan:
Ideally, you shouldn't have to do that. Now that you have the correct indexes in place, could you show us the EXPLAIN ANALYZE output for both cases (enable_seqscan = on and off)? Also, you might try leaving enable_seqscan = on, and seeing how far you have to decrease random_page_cost to get the planner to choose indexscan. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster