The recommendation before dropping a table is to do a DELETE then VACUUM RETENTION 0 (recommended in DEV).

If you DROP the table without doing a DELETE|VACUUM, your table will be soft deleted with your entire data (permanently deletedin 30 days) and you cannot do a VACUUM anymore.

In such cases, can I safely delete those soft deleted table folders straight from my storage given that these tables will not be used anymore? I want to do a cleanup in my storage and save cost.