Mathieu De Zutter <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to