Database Size not getting decreased even after removed all the rows from table ?
Inserted thousands of rows in database and now dropped all rows, Still database size in not getting decreased, VACUUM not working, What can I do to recover database space ?
1 Reply
other-emerald•2y ago
xposting from #General chat for future reference:
For each branch:
1. Delete data
2. VACUUM table;
3. Set retention window to 0 in Settings > Storage
4. Wait ~20 minutes for the storage service to update consumption metrics
The reason you need to set retention window to 0 is if not, the deleted rows are still saved so that you can roll back to a previous state.