I've got an RDS Postgresql 12 instance that allocated 11,000,000 MB of io1 disk space, and there's 7,300,000 MB of Free Storage Space.
That means the database is only using 11TB - 7.3TB = 3.7TB of disk space, right? Or am I missing something?
Thus, I spun up a new instance that allocated 5TB of disk space, did a pg_dump and pg_restore.
During the pg_restore, Free Storage Space linearly dropped to zero, and then spiked up when AWS automatically added 2.5TB.
What's going on? Why is the new instance using more disk space?
And weirdly, free space has slowly increased, even though I haven't touched the system since the restore finished.