🔗 What's new in PostgreSQL 19

Postgres 19 finally introduces a built-in method to shrink bloated tables with the new REPACK command, allowing online rewrites without locking. Previously, users relied on extensions like pg_repack and pg_squeeze to manage table bloat. Along with this, JIT compilation is disabled by default, shifting the responsibility of performance optimization to users. The query planner has also seen improvements, particularly with eager aggregation, which optimizes queries by pre-aggregating data before joins. Smaller updates include new SQL features, enhanced foreign-key performance, and logging improvements. Overall, these enhancements aim to boost usability and performance in database management.