title: How to free up vertica raw space after deleting records
body: <p>We are using Vertica community edition which has raw data limit of 1TB.</p>
  
  <p>recently reached 1 TB raw data limit so we decided to delete some records from all tables. After deletion of old records Vertica still shows Utilization  : 104% </p>
  
  <pre><code>dbadmin=&gt; SELECT GET_COMPLIANCE_STATUS();
  GET_COMPLIANCE_STATUS
  ----------------------------------------------------------------------------------------
  Raw Data Size: 1.04TB +/- 0.10TB
  License Size : 1.00TB
  Utilization  : 104%
  Audit Time   : 2014-09-04 13:05:24.020979-04
  Compliance Status : The database is in compliance with respect to raw data size.
  
  No expiration date for a Perpetual license
  
  NOTICE: Recent audits suggests a change in compliance status. We are awaiting additional data points to confirm.
  (1 row)
  </code></pre>
  
  <p>Any idea how to free up that space ?</p>