Hacker News AIT2·Open Source
58 pts
PostgreSQL 19 is released with a new REPACK command that reclaims disk space and reorganizes table contents, with a CONCURRENTLY mode that avoids blocking reads and writes. It also adds the pg_plan_advice and pg_stash_advice extensions for planner control, enables logical replication without a server restart, supports sequence-value replication, and adds read-your-writes consistency on standbys.