pg_squeeze
A PostgreSQL extension that automatically removes table bloat and optionally sorts tuples by an index, using background workers and logical decoding.
What is pg_squeeze?
pg_squeeze is a PostgreSQL extension that automatically reclaims unused space (bloat) from tables and can physically reorder tuples according to a specified index. It performs these operations concurrently with regular reads and writes, similar to the CLUSTER command but without blocking access. The project aims to replace pg_repack by implementing functionality purely on the server side using modern PostgreSQL features.
Database administrators and DevOps engineers managing PostgreSQL databases who need to maintain performance by reducing table bloat without downtime. It's particularly valuable for teams running large, write-heavy databases where table fragmentation impacts query performance.
Developers choose pg_squeeze over alternatives like pg_repack because it's a pure server-side implementation that leverages PostgreSQL's background workers and logical decoding for simpler configuration and unattended operation. It provides finer control over scheduling, tablespace management, and concurrency impact with minimal overhead compared to trigger-based solutions.
Overview
A PostgreSQL extension for automatic bloat cleanup
Use Cases
Best For
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
