On Sat, Aug 25, 2018 at 11:42:35AM -0700, Andres Freund wrote: > > > On August 25, 2018 11:41:11 AM PDT, Bruce Momjian <br...@momjian.us> wrote: > >On Sun, Aug 12, 2018 at 11:21:26AM +0200, Adrien Nayrat wrote: > >> Hello, > >> > >> It seems this feature is missing in releases notes ? > >> > >> commit 1f6d515a67ec98194c23a5db25660856c9aab944 > >> Author: Robert Haas <rh...@postgresql.org> > >> Date: Mon Aug 21 14:43:01 2017 -0400 > >> > >> Push limit through subqueries to underlying sort, where possible. > >> > >> Douglas Doole, reviewed by Ashutosh Bapat and by me. Minor > >formatting > >> change by me. > >> > >> Discussion: > >> > >http://postgr.es/m/cade5jyluugneeusyw6q_4mzfytxhxavcqmgasf0yiy8zdgg...@mail.gmail.com > > > >I looked into this and it is usually a detail we don't have in the > >release notes. It isn't generally interesting enough to user. > > This seems quite relevant. Both because it addresses concerns, but also can > lead to a worse plan.
Well, our normal logical is whether the average user would adjust their behavior based on this change, or whether it is user visible. I thought it was a contrived-enough query that this was not the case, but I would be interested to hear what others think. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +