pg_squeeze is a PostgreSQL extension that reclaims space in bloated tables without blocking read or write access. It provides a non-intrusive alternative to VACUUM FULL by creating a new compacted copy of the table in the background. It’s particularly useful for maintaining performance in large, heavily updated databases.
Features
- Reclaims space from bloated tables without downtime
- Works without blocking concurrent queries or updates
- Supports automatic and scheduled squeezing
- Handles indexes and foreign keys safely
- Logging and monitoring of squeeze operations
- Reduces table size and improves performance
Categories
DatabaseLicense
MIT LicenseFollow pg_squeeze
Other Useful Business Software
Train ML Models With SQL You Already Know
Build and deploy ML models using familiar SQL. Automate data prep with built-in Gemini. Query 1 TB and store 10 GB free monthly.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of pg_squeeze!