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
99.99% Uptime for MySQL and PostgreSQL Databases
Cloud SQL Enterprise Plus delivers near-zero downtime with 35 days of point-in-time recovery. Supports MySQL, PostgreSQL, and SQL Server.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of pg_squeeze!