The Bloat Busters: pg_repack vs pg_squeeze

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

As the database size increases and the number of transactions per second rise, you'll inevitably face the challenge of the table bloat. Although PostgreSQL assists as much as possible with its auto-vacuum feature , there will come a time when you will compel whether to run VACUUM FULL . Unless you have option of longish downtime windows, this is not an easy decision. Thankfully, the rich…

Read on boringsql.com ↗