I have a table in RDS Aurora (Postgres) with ~5M rows. In this table I had a text column that was very large (50K bytes on many occasions).
The total size of the table reached 60GB.
I now emptied this column. It only contains very short text (up to 2 characters) but the size of the table didn't change significantly. How can I trigger a clean-up for it?
My next step will be to remove this column altogether. What should I do then to reduce the size of the table?
