Postgres Pro
Downloads
Home   >   mailing lists

Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. - Mailing list pgsql-sql

From David G. Johnston
Subject Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Date
Msg-id CAKFQuwaKBdk3MwnqifhttE3TrDbWwYtmrMOTi2WizceTQ6adWA@mail.gmail.com
Whole thread Raw
In response to Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.  ("Venkatesan, Sekhar" <sekhar.venkatesan@emc.com>)
List pgsql-sql
Tree view
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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Next
From: Adrian Klaver
Date:
Subject: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.