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
