Get the latest tech news
The Bloat Busters: pg_repack vs. pg_squeeze
Deep dive into SQL & PostgreSQL to build reliable, rock-solid solutions with tips and tricks that keep business online. Data is everything. Explore, learn and innnovate to get them where you need faster and more efficiently.
Although it won’t be included in this comparison, if planned in advance, it can simplify certain maintenance tasks, improve performance, and make routine vacuuming faster and more efficient. The drawback you might experience when terminating the process (which may be necessary for various reasons, such as impact on the running environment) is that it won’t clean up all the fragments as it won't remain connected to the target database. The very opinionated difference between the tools can be made, using pg_squeeze for automated, continuous cleaning of specific tables, and pg_repack as the heavyweight champion of controlled setups.
Or read this on Hacker News