The PostgreSQL Global Development Group has released PostgreSQL 17.3, a maintenance release that includes performance improvements and bug fixes.
Performance Improvements
- JSON Path Optimization — JSON/JSONB path queries are now up to 3x faster with improved operator pushdown
- Parallel Query — Better cost estimation for parallel plans, resulting in more queries using parallel workers
- Logical Replication — Conflict detection and resolution for logical replication subscribers
- MERGE Improvements — MERGE command now supports RETURNING clause and works with partitioned tables
Database administrators running PostgreSQL 17 should upgrade to 17.3 for these optimizations. The release also includes several important security fixes.
