PostgreSQL 16 Beta 1

#1

Post by jkatz05 » Thu, May 25, 2023, 1:08 PM UTC

PostgreSQL 16 Beta 1
postgresql.org

Re: PostgreSQL 16 Beta 1

#2

Post by klysm » Thu, May 25, 2023, 1:53 PM UTC

Glad to see the move off of autoconf to meson.

Re: PostgreSQL 16 Beta 1

#3

Post by itsthecourier » Thu, May 25, 2023, 2:05 PM UTC

COPY from files up to 300% faster

Load Balancing from client libs

Support for CPU acceleration using SIMD for both x86 and ARM architectures, including optimizations for processing ASCII and JSON strings

new pg_stat_io view that provides information on I/O statistics

Re: PostgreSQL 16 Beta 1

#4

Post by craigkerstiens » Thu, May 25, 2023, 2:13 PM UTC

For being "boring and stable" technology, Postgres 16 includes 200 features, which is on par with each of prior years releases. If you're looking for the full set of features it's available here - https://www.postgresql.org/docs/16/release-16.html.

Personal favorites on the list include:

- load_balance_hosts, which is an improvement to libpq so you can load balance across multiple Postgres instances.

- Logical replication on standbys

- pg_stat_io which is a new view that shows IO details.

Re: PostgreSQL 16 Beta 1

#5

Post by garyclarke27 » Thu, May 25, 2023, 2:30 PM UTC

Postgresql is amazing but I must say the last few updates have been a bit disappointing.

Still waiting for automatic incremental updates for materialized views - been worked on for several years but still not released!

https://wiki.postgresql.org/wiki/Incremental_View_Maintenanc...

https://github.com/sraoss/pg_ivm

Re: PostgreSQL 16 Beta 1

#6

Post by h1fra » Thu, May 25, 2023, 2:34 PM UTC

Postgres getting good updates at slow but steady pace over many decades is really impressive.

Re: PostgreSQL 16 Beta 1

#7

Post by jasfi » Thu, May 25, 2023, 2:37 PM UTC

I look forward to seeing some benchmarks. Especially to see the effect of the SIMD optimizations.

Re: PostgreSQL 16 Beta 1

#8

Post by dimmke » Thu, May 25, 2023, 2:46 PM UTC

[flagged]

Re: PostgreSQL 16 Beta 1

#9

Post by tuetuopay » Thu, May 25, 2023, 2:50 PM UTC

This is an exciting release to be sure. Very happy to see that the CPU improvements include ARM, diversity is good!

Given the current release pace, I'd love to have another upgrade path than `pg_dump | psql`. That would remove a great deal of friction in prod.

Re: PostgreSQL 16 Beta 1

#10

Post by Fgehono » Thu, May 25, 2023, 2:53 PM UTC

craigkerstiens wrote: post #4

For being "boring and stable" technology, Postgres 16 includes 200 features, which is on par with each of prior years releases. If you're looking for the full set of features it's available here - https://www.postgresql.org/docs/16/release-16.html . Personal favorites on the list include: - load_balance_hosts, which is an improvement to libpq so you can load balance across multiple Postgres instances. - Logical repli…

Could you elaborate on the load balancing?

Is this a replacement for PG bouncer and similar?