`pg_repack` doubling project storage
Apologies for the double post, but this issue is time-sensitive and we need to determine the correct approach promptly. I previously posted ❓｜questions-and-answersFree up storage with `pg_repack` requesting guidance regarding
Summary
By the time I posted the issue yesterday our project’s total storage was approximately 1.5 GB, with the main database initially around 900 MB. The project contains a single branch and two databases, though one of them has no data.
After running
We have a specific use case where we routinely ingest data from an external source but only need to retain the most recent X days. Without periodic cleanup, the database could grow to hundreds or even thousands of gigabytes. Because of this, it is essential that cleanup operations function consistently and that we understand why storage usage increased after running
Any help or guidance would be highly appreciated.
pg_repackSummary
By the time I posted the issue yesterday our project’s total storage was approximately 1.5 GB, with the main database initially around 900 MB. The project contains a single branch and two databases, though one of them has no data.
After running
pg_repackWe have a specific use case where we routinely ingest data from an external source but only need to retain the most recent X days. Without periodic cleanup, the database could grow to hundreds or even thousands of gigabytes. Because of this, it is essential that cleanup operations function consistently and that we understand why storage usage increased after running
pg_repackAny help or guidance would be highly appreciated.
