Re: PostgreSQL 16 release announcement draft
От | David Rowley |
---|---|
Тема | Re: PostgreSQL 16 release announcement draft |
Дата | |
Msg-id | CAApHDvrgx=P-z2Fr3G-yPNqkm=Q71vKFS52JbGwvvo+0V-D=zA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: PostgreSQL 16 release announcement draft ("Jonathan S. Katz" <jkatz@postgresql.org>) |
Ответы |
Re: PostgreSQL 16 release announcement draft
|
Список | pgsql-hackers |
On Thu, 24 Aug 2023 at 05:55, Jonathan S. Katz <jkatz@postgresql.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
В списке pgsql-hackers по дате отправления: