CYBERTEC outlines its contributions to PostgreSQL 19, covering several significant features and fixes. The headline addition is the new REPACK command (replacing VACUUM FULL and CLUSTER), which gains a CONCURRENTLY option using logical replication to compact tables online — essentially integrating CYBERTEC's pg_squeeze tool into core PostgreSQL. Other contributions include eager aggregation (a query planner optimization allowing aggregates to be pushed through joins), fixing vacuumdb --analyze-only to process partitioned tables, enabling log_lock_waits by default, and adding a FLUSH_UNLOGGED option to the CHECKPOINT command. A major community-wide change also covered is disabling JIT compilation by default due to poor cost estimation leading to OLTP performance regressions. The post also details debugging work around NUMA observability on 32-bit Linux and Docker environments, including a Linux kernel patch.
Table of contents
The big change: REPACK CONCURRENTLY by Antonin HouskaDocumentation and Usability: Laurenz AlbePortability and Testing: Christoph BergCollaboration across the community: JIT is off by defaultWe care about details: Is "alloced" a word?Sort: