Data Purge and Recycle

In Databend, the data is not truly deleted when you run DROP, TRUNCATE, or DELETE commands, allowing for time travel back to previous states.

There are two types of data:

History Data: Used by Time Travel to store historical data or data from dropped tables.
Temporary Data: Used by the system to store spilled data.

If the data size is significant, you can run several commands (Enterprise Edition Features) to delete these data and free up storage space.

Purge Drop Table Data

Deletes data files of all dropped tables, freeing up storage space.

VACUUM DROP TABLE;

Removes historical data for a specified table, clearing old versions and freeing storage.

VACUUM TABLE <table_name>;

Clears temporary spilled files used for joins, aggregates, and sorts, freeing up storage space.

VACUUM TEMPORARY FILES;