PostgreSQL 16 (postgresql.org)

Article summary

The PostgreSQL Global Development Group has announced the release of PostgreSQL 16, which includes performance improvements, new features, and enhancements to existing functionality. The release improves query parallelism, bulk data loading, and logical replication, and adds support for SQL/JSON syntax and new monitoring statistics. The update also includes improvements to access control and security, such as finer-grained options for managing pg_hba.conf and pg_ident.conf files. Overall, PostgreSQL 16 aims to provide a more efficient, scalable, and secure database management system.

Main themes

• PostgreSQL 16 release
• performance improvements
• SQL/JSON features
• access control and security
• upgrade process
• versioning scheme
• open-source software infrastructure
• database maintenance and performance

What commenters say

• The new release of PostgreSQL 16 includes significant performance improvements, particularly in query parallelism and bulk data loading.
• Some users are unsure about the upgrade process from RC-1 to the final release and whether pg_upgrade is required.
• The community appreciates the efforts of the PostgreSQL development team and recognizes the importance of open-source software infrastructure.
• There is a discussion about the versioning scheme and whether the project follows semantic versioning.
• Some commenters point out that PostgreSQL is a commercially sponsored project, with many contributors being paid by their employers to work on the project.
• The new SQL/JSON features and improvements to VACUUM and indexing are expected to be useful for developers and administrators.
• Regular VACUUM can help reduce table bloat, but VACUUM FULL is still necessary to reclaim space in certain cases.
• Partitioning tables can help with performance and maintenance, but it can be awkward to implement in certain frameworks.