Re: PostgreSQL 12: Feature Highlights

On Sat, May 18, 2019 at 11:34:34PM +1200, David Rowley wrote:
> On Sat, 18 May 2019 at 14:30, Bruce Momjian <bruce@momjian.us> wrote:
> > No one has suggested new wording, so I don't know what you are
> > complaining about.  In fact, the wording we have now is by Amit Langote.
> 
> https://www.postgresql.org/message-id/CAKJS1f8R6DC45bauzeGF-QMaQ90B_NFSJB9mvVOuhKVDkajehg@mail.gmail.com

The second item I added yesterday at the prompting of Amit:

    commit 05685897f0
    Author: Bruce Momjian <bruce@momjian.us>
    Date:   Fri May 17 11:31:49 2019 -0400
    
        docs:  split out sort-skip partition item in PG 12 release notes
    
        Discussion:
    https://postgr.es/m/0cf10a27-c6a0-de4a-cd20-ab7493ea7422@lab.ntt.co.jp

    > Avoid sorting when partitions are already being scanned in the
    > necessary order (David Rowley)

The first one needs to reference visible effects, so I would add:

    Consider additional optimizations for queries referencing
    partitioned tables that only affect a single partition

Does that work?

It seems you never got a reply to that email, perhaps because I thought
Amit's next email was covering the same issue.  I am sorry for that.

-- 
  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 +