Mathieu De Zutter <mathieu(at)dezutter(dot)org> writes:
> However, i dont want the view to be presorted, but sort it in the
> queries that use the view. When I do that, the index I have on that
> field seems to be ignored. It stretches so far that, when I sort the
> view on A and sort the query on A too, the query will try to sort
> _again_ _without_ index and thus lose all performance.
This is a limitation of the 7.3 query planner. 7.4 should do better.
regards, tom lane