Re: PostgreSQL 16 release announcement draft
От | jian he |
---|---|
Тема | Re: PostgreSQL 16 release announcement draft |
Дата | |
Msg-id | CACJufxGNvaSdEk_BWBpMyb=p_0uhs6RMtH3tdc6TeweOdm51DQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: PostgreSQL 16 release announcement draft (jian he <jian.universality@gmail.com>) |
Ответы |
Re: PostgreSQL 16 release announcement draft
|
Список | pgsql-hackers |
>>> 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 also <<<< "the query planner ....., and execute window functions more efficiently." since the query planner doesn't execute anything. probably "and optimize window functions execution"?
В списке pgsql-hackers по дате отправления: