| From: | "Venkatesan, Sekhar" <sekhar(dot)venkatesan(at)emc(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(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 05:53:38 |
| Message-ID: | F84DE43FDACD4C45AA84E2DA016FAE2F1C65BF1C@MX105CL01.corp.emc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)g(dot)johnston(at)gmail(dot)com]
Sent: Tuesday, February 09, 2016 11:20 AM
To: Venkatesan, Sekhar
Cc: Tom Lane; pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Question on PostgreSQL DB behavior w.r.t JOIN and sort order.
On Monday, February 8, 2016, Venkatesan, Sekhar <sekhar(dot)venkatesan(at)emc(dot)com<mailto:sekhar(dot)venkatesan(at)emc(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2016-02-09 05:57:37 | Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. |
| Previous Message | David G. Johnston | 2016-02-09 05:50:14 | Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. |