Postgres 19 finally reorganizes tables without locking, and borrows GROUP BY ALL from DuckDB (snowflake.com)
Snowflake's Craig Kerstiens walks through the Postgres 19 beta: REPACK CONCURRENTLY reorganizes bloated tables without locks (no more pg_repack), partitions can now merge and split in place, autovacuum gets parallel workers, and SQL/PGQ brings graph queries to relational data.
The thread wanted what's still missing more than what shipped. A 15-year Postgres user in science flagged the absent columnar storage as datasets balloon; others miss materialized views and in-place major upgrades. And the top nitpick: GROUP BY ALL was DuckDB's idea first.
Sign in to save