Gaetano Mendola <mend...@gmail.com> writes:
> because of that sort in the view definition the first query above
> takes not less than 3 seconds. I have solved this performance issue
> removing the sort from the view definition and putting it in the
> select reducing the time from > 3secons to < 150ms.

> Can not the optimizer take rid of that useless sort on those
> kind of queries ?

It is not the optimizer's job to second-guess the user on whether a sort
is really needed there.  If we did make it throw away non-top-level
sorts, we'd have hundreds of users screaming loudly.

                        regards, tom lane

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to