David Garamond <lists@zara.6.isreserved.com> writes: > The table contain +- 1 mil records, all of the actual version of the > queries below return < 10 rows, so an index should be used. Using an > index scan, the query ran < 100ms. Using seq scan, 2-3 secs. So there is > no good reason why a seq scan should be used, especially in a case of > b='foo' or b='bar'. [shrug...] We can't possibly diagnose a bad-plan-choice problem with the amount of information you've provided. See http://techdocs.postgresql.org/guides/SlowQueryPostingGuidelines regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
