postgresqlamazon-web-servicesamazon-rds

How to reduce storage (scale down) my AWS RDS instance?

I have a AWS RDS (Postgres) instance with storage SSD 1000 GB, but the data is only 100 GB of size.

How can I scale down the storage resource of AWS RDS easily?

Solution

  • RDS does not allow you to reduce the amount of storage allocated to a database instance, only increase it.

    To move your database to less storage you would have to create a new RDS instance with your desired storage space, then use something like pg_dump/pg_restore to move the data from the old database to the new one.

    Also be aware that an RDS instance with 1,000GB of SSD storage has a base IOPS of 3,000. An RDS instance with 100GB of SSD storage has a base IOPS of 300, with occasional bursts of up to 3,000.