https://community.databricks.com/t5/data-engineering/performance-improvement-after-running-vacuum-commands/m-p/21067#M14305 <P>How often should I run VACUUM commands? Will running the VACUUM command on a Delta table improve my read/write performance or is it just the storage benefits. </P> Wed, 23 Jun 2021 23:04:09 GMT brickster_2018 2021-06-23T23:04:09Z https://community.databricks.com/t5/data-engineering/performance-improvement-after-running-vacuum-commands/m-p/21067#M14305 <P>How often should I run VACUUM commands? Will running the VACUUM command on a Delta table improve my read/write performance or is it just the storage benefits. </P> Wed, 23 Jun 2021 23:04:09 GMT https://community.databricks.com/t5/data-engineering/performance-improvement-after-running-vacuum-commands/m-p/21067#M14305 brickster_2018 2021-06-23T23:04:09Z https://community.databricks.com/t5/data-engineering/performance-improvement-after-running-vacuum-commands/m-p/21068#M14306 <P>VACUUM removes uncommitted/stale files from the Storage. The primary benefit is to save the storage cost. Ideally running VACUUM should not show any performance improvement as Delta does not list the storage directories but rather access the files directly. However in the past due to corner case issues on the storage side, we have seen performance improvement after running VACUUM. Those issues are fixed </P> Wed, 23 Jun 2021 23:08:03 GMT https://community.databricks.com/t5/data-engineering/performance-improvement-after-running-vacuum-commands/m-p/21068#M14306 brickster_2018 2021-06-23T23:08:03Z