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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Venkatesan, Sekhar" <sekhar(dot)venkatesan(at)emc(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Date: 2016-02-09 06:00:55
Message-ID: CAKFQuwaKBdk3MwnqifhttE3TrDbWwYtmrMOTi2WizceTQ6adWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Monday, February 8, 2016, Venkatesan, Sekhar <sekhar(dot)venkatesan(at)emc(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2016-02-09 06:01:53 Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
Previous Message Rob Sargent 2016-02-09 05:57:37 Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order.