Hi,
On 2023-05-24 13:06:30 -0400, Jonathan S. Katz wrote:
> PostgreSQL 16 Feature Highlights
> --------------------------------
>
> ### Performance
>
> PostgreSQL 16 includes performance improvements in query execution. This release
> adds more query parallelism, including allowing `FULL` and `RIGHT` joins to
> execute in parallel, and parallel execution of the `string_agg` and `array_agg`
> aggregate functions. Additionally, PostgreSQL 16 can use incremental sorts in
> `SELECT DISTINCT` queries. There are also several optimizations for
> [window queries](https://www.postgresql.org/docs/16/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS),
> improvements in lookups for `RANGE` and `LIST` partitions, and support for
> "anti-joins" in `RIGHT` and `OUTER` queries.
>
> This release also introduces support for CPU acceleration using SIMD for both
> x86 and ARM architectures, including optimizations for processing ASCII and JSON
> strings, and array and subtransaction searches. Additionally, PostgreSQL 16
> introduces [load balancing](https://www.postgresql.org/docs/16/libpq-connect.html#LIBPQ-CONNECT-LOAD-BALANCE-HOSTS)
> to libpq, the client library for PostgreSQL.
I think the relation extension improvements ought to be mentioned here as
well? Up to 3x faster concurrent data load with COPY seems practically
relevant.
Greetings,
Andres Freund