Re: PostgreSQL 12: Feature Highlights

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: PostgreSQL 12: Feature Highlights
Дата
Msg-id 20190518132031.zjyxgvys7unan53f@momjian.us
обсуждение исходный текст
Ответ на Re: PostgreSQL 12: Feature Highlights  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: PostgreSQL 12: Feature Highlights  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-advocacy
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 +



В списке pgsql-advocacy по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: PostgreSQL 12: Feature Highlights
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PostgreSQL 12: Feature Highlights