The database is about to store considerably more data. Consider a solution that will prune old data (transactions, batches, submittals, etc) when we are sure that they are not needed.

Since postgresql doesn't support retention, this will probably end up being a service that runs periodically checking for stale data and cleaning it up.