"One of the most anticipated new features in PostgreSQL 17 is native support for incremental backups. Previously, you had to use third-party programs for this; now, it's baked into the server."
"PostgreSQL 17 significantly expands its SQL/JSON capabilities, introducing new functions like JSON_TABLE(), JSON_EXISTS(), JSON_QUERY(), and JSON_VALUE. These additions bring PostgreSQL more in line with the SQL:2023 standard."
"The new PostgreSQL also introduces the ability to configure the Simple Least Recently Used (SLRU) cache, which is crucial for handling subtransactions. This feature allows applications with high transaction volumes to run more efficiently."
"PostgreSQL also -- finally -- improved logical replication, which enables you to replicate data between PostgreSQL databases... Database administrators won't have to deal with this delay from this release on."
Collection
[
|
...
]