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: https://www.youtube.com/playlist?list=PLF2cSNGGDBgdiNS-o2jHgL29QKtvRMrZi

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

Видео PostgreSQL 17 Top New Features — Incremental Backup, JSON, Performance Optimizations канала ABCloudz