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 <[email protected]> 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 <[email protected]>
	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/[email protected]

	> 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  <[email protected]>        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 +