Release Radar: Reducing Bloat and Improving Query Performance With EDB Support for pg_squeeze

February 28, 2024

EDB is pleased to announce support of the popular PostgreSQL extension pg_squeeze on our database distributions and across different deployment types.

Addressing higher infrastructure cost, availability and Postgres performance issues

For organizations managing the demands of modern database workloads, instances of table bloat in their Postgres environments can be particularly troublesome. Organizations are often unaware of table bloat in their Postgres environments or its adverse impacts—higher infrastructure costs, as well as database availability and performance issues.

The pg_squeeze PostgreSQL extension is designed to address this table bloat issue by reorganizing tables to reclaim space and optimize data organization, which enhances disk space efficiency and query performance. Unlike VACUUM in Postgres, pg_squeeze performs these operations with minimal locks, reducing bloat without requiring downtime. As a result, Postgres can maintain optimal performance and space efficiency, even in systems with high transaction rates and frequent UPDATEs—all without the need for disruptive maintenance windows. 

EDB’s support of pg_squeeze takes advantage of a more modern design that carries less liability for data corruption than using pg_repack. By adding this new feature to our Postgres solutions, EDB expands our commitment to enable developers to optimize performance for modern database workloads, minimize downtime and reduce costs.
 

Share this

More Blogs