PostgreSQL 19 hit release candidate. Here's what's worth testing.

What happened

The PostgreSQL project released the first release candidate of PostgreSQL 19 on October 15, 2026. A second candidate is planned for November 12. General availability is planned for November 19, unless a problem forces a delay.

Beta overviews, which can still change, point to a few headline features:

• REPACK and REPACK CONCURRENTLY rebuild bloated tables with less locking than VACUUM FULL or CLUSTER. Until now, many teams needed the pg_repack extension for this.
• Parallel autovacuum, controlled by a new setting, plus better prioritization and progress reporting.
• pg_plan_advice, which lets you steer the planner on a problem query without rewriting the application's SQL.
• Replication changes. Sequences can be replicated, and logical replication can be enabled without a restart.

There are plenty of smaller additions too, including GROUP BY ALL and JSON output from COPY.

So what for your business

A new Postgres major version is rarely urgent, and it's never a drop-in swap. The RC announcement is explicit that you move between major versions with pg_upgrade or dump and restore.

But the features above target real operational pain: table bloat, vacuum falling behind, and the one query that suddenly picks a bad plan. If any of those cost you an incident in the last year, this release deserves a proper look.

If you run on a managed provider, the date isn't yours to pick. Find out when they plan to offer 19, and whether the upgrade happens in place or by moving to a new instance.

What to do this month

1. Restore a production snapshot onto an RC instance. Use real data, not a toy set.
2. Replay your slowest and most frequent queries. Compare plans and timings with your current version.
3. Try REPACK CONCURRENTLY on your most bloated table. Watch runtime, WAL volume, replica lag and temporary disk use.
4. Check your extensions. Make sure every one you depend on supports 19.
5. Schedule the real upgrade after GA, not on it. Wait for the first minor release, and rehearse with a timed dry run.