Free up storage with `pg_repack`
Hey everyone!
We have a specific use case where we regularly fetch data from a source, but we only need to keep the last X days. We tried deleting older rows and then running
Our goal is to free up space to lower storage costs, and we also can’t run a VACUUM FULL because we want to avoid service disruption.
Could someone explain the best way to achieve this? Ideally, we’d like to run
Any guidance would be greatly appreciated!
We have a specific use case where we regularly fetch data from a source, but we only need to keep the last X days. We tried deleting older rows and then running
pg_repackOur goal is to free up space to lower storage costs, and we also can’t run a VACUUM FULL because we want to avoid service disruption.
Could someone explain the best way to achieve this? Ideally, we’d like to run
pg_repack Any guidance would be greatly appreciated!
