PostgreSQL 19 introduces REPACK (CONCURRENTLY), a built-in command that rewrites bloated tables online without extensions, using logical decoding to maintain a consistent snapshot and record changes during the rewrite. The author benchmarked REPACK against pg_squeeze and pg_repack extensions on a 90-million-row table, finding REPACK comparable in performance but more practical for managed services since it requires no shared libraries or restart.
PostgreSQL 19 introduces REPACK (CONCURRENTLY), a built-in command for online table repacking that uses logical decoding to minimize downtime. Radim Marek benchmarks REPACK against pg_squeeze and pg_repack extensions, finding REPACK efficient with WAL management and suitable for managed services since it requires no extensions or shared libraries.