Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Дата
Msg-id CAKFQuwaKBdk3MwnqifhttE3TrDbWwYtmrMOTi2WizceTQ6adWA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.  ("Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>)
Список pgsql-sql
Дерево обсуждения
On Monday, February 8, 2016, Venkatesan, Sekhar <sekhar.venkatesan@emc.com> wrote:

Yes. is there an option/configuration to tell the postgres optimizer/planner to generate plans to include the sort order instead of speed? 

No.  The planner chooses based upon least cost of the exact query given to it.  If that query does not have order by the system will not guarantee any specific output order.

David J.

В списке pgsql-sql по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.