Summary
Currently the prod graduate database has 100gb allocated to it, which is far overkill compared to usage (it appears to use <1gb at present). Shrinking a database is non-trivial but will have some cost-savings if we can pull it off. The ideal target is 20gb (the minimum size) for graduate for now (we can always increase storage size later, but can't shrink it).
Tasks
- Determine how to shrink a database's size (start here: https://repost.aws/knowledge-center/rds-db-storage-size).
- Create a new DB instance with the shrunk size.
- Migrate prod to use the new instance.
- Verify that the new instance contains the same data.
- Shut down the old instance