Martijn van Oosterhout <kleptog@xxxxxxxxx> writes: > At a guess your table is not big enough to make an index worthwhile. If > your table is only a few pages long, it's just not efficient to lookup > an index first. > If you post the results of EXPLAIN ANALYZE we can tell you for sure. Actually, it would be interesting to see EXPLAIN ANALYZE for the query both with enable_sort = on and enable_sort = off. That would show what the planner thinks the relative costs are as well as what the true costs are. regards, tom lane
