Re: Index usage for sorted query - Mailing list pgsql-performance

Markus Schaber <schabios@logi-track.com> writes:
> But as it fetches all the rows through the index, why doesn't it
> recognize that, fetching this way, the rows are already sorted by
> l_postcode?

Tell it to "ORDER BY cd, l_postcode".

> Is Postgresql 8 more intelligend in this case?

No.

            regards, tom lane