From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
---|---|
To: | jian he <jian(dot)universality(at)gmail(dot)com> |
Cc: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, chelseadole(at)gmail(dot)com |
Subject: | Re: PostgreSQL 16 release announcement draft |
Date: | 2023-08-23 12:02:51 |
Message-ID: | CAApHDvph5ueZtRe0MN=qGUoqqV4wJOeiBEfoCG6nDua_ZYZz6A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, 23 Aug 2023 at 22:21, jian he <jian(dot)universality(at)gmail(dot)com> wrote:
>
> >>>
> PostgreSQL 16 improves the performance of existing PostgreSQL functionality
> through new query planner optimizations. In this latest release, the query
> planner can parallelize `FULL` and `RIGHT` joins, utilize incremental sorts for
> `SELECT DISTINCT` queries, and execute window functions more efficiently. It
> also introduces `RIGHT` and `OUTER` "anti-joins", which enable users to identify
> rows not present in a joined table.
> >>>
>
> I think "utilize incremental sorts is for" something like select
> my_avg(distinct one),my_sum(one) from (values(1),(3)) t(one);
> so it's not the same as `SELECT DISTINCT` queries?
> ref: https://git.postgresql.org/cgit/postgresql.git/commit/?id=1349d2790bf48a4de072931c722f39337e72055e
The incremental sorts for DISTINCT will likely be a reference to
3c6fc5820, so, not the same thing as 1349d2790. I don't see anything
there relating to 1349d2790.
> also
> <<<< "the query planner ....., and execute window functions more efficiently."
> since the query planner doesn't execute anything. probably "and
> optimize window functions execution"?
Yeah, that or "and optimize window functions so they execute more
efficiently" is likely an improvement there.
David
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Gustafsson | 2023-08-23 12:48:26 | Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc? |
Previous Message | Alexander Kukushkin | 2023-08-23 11:44:52 | Re: pg_rewind WAL segments deletion pitfall |