| From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
|---|---|
| To: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
| Cc: | jian he <jian(dot)universality(at)gmail(dot)com>, 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 21:07:44 |
| Message-ID: | CAApHDvrgx=P-z2Fr3G-yPNqkm=Q71vKFS52JbGwvvo+0V-D=zA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 24 Aug 2023 at 05:55, Jonathan S. Katz <jkatz(at)postgresql(dot)org> wrote:
> We could add something about 1349d2790 -- do you have suggested wording?
I think it's worth a mention. See the text added in square brackets below:
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, [generate more
optimal plans for
queries containing aggregate functions with a `DISTINCT` or `ORDER BY` clause,]
utilize incremental sorts for `SELECT DISTINCT` queries, and optimize
window function
executions so they execute more efficiently. It also introduces
`RIGHT` and `OUTER`
"anti-joins", which enable users to identify rows not present in a joined table.
Thanks
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Gustafsson | 2023-08-23 21:12:50 | Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc? |
| Previous Message | Tom Lane | 2023-08-23 21:02:51 | Re: Cirrus-ci is lowering free CI cycles - what to do with cfbot, etc? |