RDS Storage full with 1.6TB storage while the DB is only 20 GB

Question

My databases in total size are 20 GB. But the RDS instance had a storage full error and enabling auto scaling it went to 1.6 TB.

20 GB vs 1.6 TB is crazy. I have looked at logs, double checked DB size etc. but cannot find any usual suspects. Is there a process to identify the culprit?

Answer

Is this RDS PostgreSQL or MySQL?

For PostgreSQL, the VACUUM command can be used to remove dead tuples which occupy disk space. Refer to [Understanding autovacuum in Amazon RDS for PostgreSQL environments](https://aws.amazon.com/blogs/database/understanding-autovacuum-in-amazon-rds-for-postgresql-environments/) for more information.

After that, you may want to [restore database snapshot](https://repost.aws/knowledge-center/restore-rds-instance-from-snapshot) to a new RDS instance.

RDS Storage full with 1.6TB storage while the DB is only 20 GB

相關內容