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

Поиск
Список
Период
Сортировка
От Venkatesan, Sekhar
Тема Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Дата
Msg-id F84DE43FDACD4C45AA84E2DA016FAE2F1C65BF1C@MX105CL01.corp.emc.com
обсуждение исходный текст
Ответ на Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.  (Rob Sargent <robjsargent@gmail.com>)
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-sql
Дерево обсуждения

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

 

From: David G. Johnston [mailto:david.g.johnston@gmail.com]
Sent: Tuesday, February 09, 2016 11:20 AM
To: Venkatesan, Sekhar
Cc: Tom Lane; pgsql-sql@postgresql.org
Subject: Re: [SQL] Question on PostgreSQL DB behavior w.r.t JOIN and sort order.

 

On Monday, February 8, 2016, Venkatesan, Sekhar <sekhar.venkatesan@emc.com> wrote:

Is there a way to tell the optimizer to retain the sort order if that is possible please?

 

 

You mean, besides the ORDER BY clause?

 

David J. 

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

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