Reduce DB storage size

[1t5j0y]

Context:
When we were using gp2 disks for the database, the only cost effective way to get additional IOPS was to bump up the disk size as a result of which we have 300GB database but our usage is less than 10GB. Now that we have moved to gp3, IOPS is not tied to disk size and we can lower the database size.

The DB backups also contribute to the cost impact of this storage size.

RDS does not offer an easy way (from the console) to do this and this will require a custom solution. Refer for methods