"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

Reply via email to