Due to the free tier's space limit reduced to 512M, my project got limited, its about 560M. I deleted some unused data in table TABLE_NAME. It should be about 300M data left. But when I run
VACUUM FULL table_name
VACUUM FULL table_name
to free up disk usage, it still gave me the error
ERROR: could not extend file because project size limit (512 MB) has been exceeded (SQLSTATE 53100)
ERROR: could not extend file because project size limit (512 MB) has been exceeded (SQLSTATE 53100)