PostgreSQL has released version 17 this year with several minor improvements. The most notable feature for users is the ability to perform incremental backups internally, speeding up the backup process significantly. Other enhancements include performance optimization and the addition of some commands.
Key features in this release include:
– Addition of the JSON_TABLE command: Converts JSON fields into regular tables, allowing queries and function calls similar to querying tables.
– Performance improvements: Vacuum processes now use 20 times less memory, write-ahead log write speeds have doubled, BRIN index can utilize multiple CPU cores simultaneously, and some functions have been adjusted to support SIMD commands in newer CPU models.
– Support for incremental backups with the pg_basebackup command: Backs up data from the latest full backup file, reducing backup time. Additionally, the pg_combinebackup command combines incremental backup files into a full backup file.
For a full list of changes, refer to the release notes provided by PostgreSQL.
TLDR: PostgreSQL version 17 introduces incremental backup capabilities and performance enhancements, making data management more efficient and user-friendly.
Leave a Comment