On Sat, Aug 25, 2018 at 11:42:35AM -0700, Andres Freund wrote:
>
>
> On August 25, 2018 11:41:11 AM PDT, Bruce Momjian <bruce@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 <rhaas@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_4mZFYTxHxaVCQmGAsF0yiY8ZDggi-w@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 <bruce@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 +
