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(at)momjian(dot)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(at)momjian(dot)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(at)momjian(dot)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 +