PostgreSQL 17 in Production: Partitioning Improvements, COPY Progress, and the Features That Actually Matter

PostgreSQL 17 in Production: What Actually Matters

PostgreSQL 17 shipped with a mix of incremental improvements and a few genuine breakthroughs. After running it in production for several months, here's what actually changed our day-to-day operations.

The Big One: Improved Partitioning Performance

Partition pruning in PostgreSQL 17 is dramatically better. If you're running partitioned tables (and if you have large time-series data, you should be), this is a significant upgrade.

The Problem Before PG17