Revitalize PostgreSQL with pg_repack: A Gentle Vacuum Solution

Dec 18, 2023 · 2 min read · Overview: pg_repack is a PostgreSQL extension that lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on the...