PostgreSQL 17 Top New Features — Incremental Backup, JSON, Performance Optimizations

This is your full overview of the top new features in PostgreSQL 17. We cover incremental backup, JSON_TABLE and path functions, and all key performance improvements including VACUUM optimization, CTEs, UNION, B-tree indexing, and streaming I/O. 📺 Watch the full featured playlist:    • PostgreSQL 17 — New Features Overview   0:00 What’s in this video? 1:08 Incremental backups 1:20 What is Incremental Backup? 2:34 How Incremental Backup works in PostgreSQL 5:00 Incremental Backup — Examples 8:22 Restoring Incremental Backups 9:08 Incremental Backup vs. Point-in-Time-Recovery 11:26 PostgreSQL JSON Improvements 12:16 What is JSON? 13:14 JSON_TABLE(): Making Life Easier 14:30 JSON_TABLE(): Syntax 15:59 JSON_TABLE(): Example 1 - PASSING, FOR ORDINALITY, PATH, EXISTS 17:30 JSON_TABLE(): Example 2 - NESTED 18:34 JSON_TABLE(): Example 3 - Querying JSON from a table 19:46 Performance Enhancements — Overview 20:44 New memory management system for VACUUM 24:00 Optimization of CTE queries 26:36 Optimization of UNION operators 27:38 Improved B-tree index performance 29:39 Streaming I/O API