CrateDB is built to auto-manage the disk space and continuously optimize itself. If you delete records from a table or delete a whole table, you will in most cases not immediately see that more disk space is available.

Depending on several settings, the disk space will be made available when the next database optimization takes place. There is a command available to kick off an optimization run, but this is not throttled and might take up server resources which will block other query/insert actions (see https://crate.io/docs/crate/reference/en/latest/sql/statements/optimize.html?highlight=optimize).

Did this answer your question?