There's now a dedicated doc to cover this topic.
https://duckdb.org/docs/operations_manual/footprint_of_duckdb/reclaiming_space.html