PURGE_TABLE showed 1TB decrease in table size, but no impact on Disk Storage
Recently we had to perform UPDATE on one of the biggest columns of the biggest table in Vertica.
At the same day we saw a huge increase in disk space usage. Even though we saw that Tuple Mover performed Mergout on the above mentioned table, we manually ran
We saw that table size decreased by almost 1TB (using v_monitor.projection_storage table), though Disk Space remained absolutely the same and keeps showing the same numbers for several hours already (after PURGE_TABLE finished) (using disk_storage, v_monitor.host_resources and v_monitor.storage_usage).
Is there any time required to wait for the storage to really free the space?
Should we run/do something else to speed up the process?
(We are currently using Vertica Analytic Database v7.2.3-0)