> 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.
In response to
pgsql-performance by date
|Next:||From: robin.c.smith||Date: 2006-07-21 12:02:06|
|Subject: Re: Forcing using index instead of sequential scan?|
|Previous:||From: robin.c.smith||Date: 2006-07-21 10:40:33|
|Subject: Forcing using index instead of sequential scan?|