| 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:48:32 |
| Message-ID: | F84DE43FDACD4C45AA84E2DA016FAE2F1C65BF07@MX105CL01.corp.emc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Is there a way to tell the optimizer to retain the sort order if that is possible please?
From: David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)com]
Sent: Tuesday, February 09, 2016 11:17 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:
So from what I understand, you say in postgres, if the sort order is not specified, postgres returns results in any order. Am I right?
Yes. It will optimize for speed without any regard for maintaining any kind of ordering. You may get the desired order for various reasons but without ORDER BY you cannot be guaranteed.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-02-09 05:50:14 | Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. |
| Previous Message | David G. Johnston | 2016-02-09 05:47:18 | Re: Question on PostgreSQL DB behavior w.r.t JOIN and sort order. |