Vitaly Belman <[EMAIL PROTECTED]> writes: > Notice that the GROUP BY items added the following to the plan:
> -> Sort (cost=10454.67..10600.83 rows=58466 width=47) > Sort Key: s.series_id, s.series_name, s.series_picture Oh, I see: in the first case you need no sort at all because the output of the indexscan is already known to be sorted by s.series_id. I was thinking of a sort with more or fewer sort columns, but that's not the issue here. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html