PostgreSQL 17 Released
The big one is here. It's the newest major version of Postgres, and it takes a bigger step forward than even v16. Some of what’s new:Overhauled memory management for vacuuming, resulting in significantly lower memory usage and running time. More on this here.
- Incremental backup support.
- Faster B-tree index scans.
- MERGE enhancements, including view support.
- New functions to extract elements from UUIDs.
- WAL improvements – up to 2x write throughput on some workloads.
- Improvements to SQL/JSON support, including JSON_TABLE.
- Bulk loading improvements and perf improvements for COPY which gains the ON_ERROR ignore option to ignore errors.
- Identity columns on partitioned tables.
PG4E - Postgres for Everybody
This web site provides free / OER materials to help you learn the PostgreSQL database. You can take this course and receive a certificate at:
No comments:
Post a Comment