After we bump the current processing pipeline version, processed data of previous pipeline versions doesn't serve a purpose anymore. We should just delete it to not accrue waste.
No longer purposeful processed data is the main source of db storage at the moment in production pathoplexus (already noticeably slowing down cloning from prod to staging).
Proposed feature:
As part of bumping the processing pipeline version, after successfully having bumped the version, delete all outdated rows.
After we bump the current processing pipeline version, processed data of previous pipeline versions doesn't serve a purpose anymore. We should just delete it to not accrue waste.
No longer purposeful processed data is the main source of db storage at the moment in production pathoplexus (already noticeably slowing down cloning from prod to staging).
Proposed feature:
See this comment for an analysis of db storage: https://github.com/loculus-project/loculus/pull/3232#issuecomment-2485779144
The alternative is manually deleting old versions but I don't see reason for doing this manually when we can do it automatically.