robin(dot)c(dot)smith(at)bt(dot)com wrote:
> What is the best way to force the use of indexes in these queries?
Well, the brute-force method is to use SET enable_seqscan TO off, but if
you want to get to the bottom of this, you should look at or post the
EXPLAIN ANALYZE output of the offending queries.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/