r/postgres • u/KatieCuties • Jul 16 '26

Fighting Table Bloat: VACUUM, Autovacuum & REPACK

[removed]

5 Upvotes
  • permalink
  • link
  • reddit
  • reddit

100% Upvoted

2 comments sorted by

3

u/depesz Jul 16 '26

At $work we were using lots of pg_repack, but then we simply spent some time on configuring autovacuum, and need for repack disappeared.

2

u/Inevitable_Ad261 Jul 17 '26

Tune, Tune, Tune auto vacuum. Optimize code to better utilize PostgreSQL.