We have a Postgres 13 database that has been slowly but steadily increasing its disk usage on Amazon RDS. Right before a VACUUM(FULL, ANALYZE, VERBOSE) command it was ~300 GB, but afterwards it jumped ~50% up to ~450GB.
We would like to reclaim that disk usage, since it's hard to imagine for me how Postgres is actually requiring that extra amount after a vacuum full.
How to analyse the root cause of the increase of disk usage following a vacuum full on the RDS Postgres? And how to reduce it again?
If you need key pieces of information to help answer the question, let me know in the comments below.