Martijn van Oosterhout <kleptog@svana.org> 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