Michael Fuhr <mike@xxxxxxxx> writes: > On Mon, Nov 15, 2004 at 04:25:59PM +1100, Harvey, Allan AC wrote: >> I created an index on the dt column, ran ANALYSE then, >> EXPLAIN for some queries. >> The returned plan was always sequential search. > Could you post a query and the EXPLAIN ANALYZE output? We could > probably give better advice if we could see what's happening. Also, let's see EXPLAIN ANALYZE results after setting enable_seqscan to OFF. If that doesn't force it into an indexscan, then you have got more fundamental issues (perhaps a datatype mismatch). Note that I don't recommend turning off enable_seqscan as a production solution; but it's a useful tool for debugging. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
