PostgreSQL 19 rewrites tables in place and syncs sequences across replicas

PostgreSQL 19: A hands-on tour with runnable browser examples

PostgreSQL 19 rewrites tables in place and syncs sequences across replicas

PostgreSQL 19, released November 19, 2026, adds native REPACK for concurrent table rewrites, smarter autovacuum with real priority scores and parallel index work, and plan advice that constrains specific planner choices. Logical replication now supports FOR ALL TABLES EXCEPT and ALL SEQUENCES, so sequence state can be copied and refreshed. The article walks through each feature with runnable browser examples on a live server.

PostgreSQL 19 enables logical WAL when required without restarting this primary.

More from this day

2026-11-20