What's New in PostgreSQL 19: REPACK CONCURRENTLY, Sequence Replication, WAIT, ON CONFLICT DO SELECT and Behavior Changes
PostgreSQL 19's REPACK (CONCURRENTLY) shrinks a table like VACUUM FULL but does not stop writes: under a pgbench load VACUUM FULL dropped to 4 transactions per second while REPACK kept the traffic going. On 19 RC 2: ON CONFLICT DO SELECT, read-your-writes with WAIT FOR LSN on a standby, sequence replication, pg_plan_advice, the changed defaults, and what to expect from Npgsql/EF Core 11.
15 Nov 2026
·
11 min
·
7
