Reducing allocated storage in AWS RDS for PostgreSQL is not supported directly, because RDS does not allow reducing the allocated storage size once it has been increased — even if your actual data size is much smaller.