How to free up vertical space after deleting records

Question

We are using the Vertica community edition, which has a raw data limit of 1 TB.

recently reached a data limit of 1 TB, so we decided to delete some records from all tables. After deleting old records, Vertica still shows usage: 104%

dbadmin=> 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)

Any idea to free this space?

Answer 1

Rows that were deleted with DELETEare marked for deletion, and not immediately deleted from the physical store. You need to wait until the merger happens, advance the era or launch PURGE. For more information on deleting deleted data, see the documentation .

Answer 2

...

, , , .

Answer 3

,

select count(1) from delete_vectors;

script,

select make_ahm_now()
select purge()

script

Answer 4

. , .

,

select audit_license_size();

select make_ahm_now(); select purge();

, truncate().

  select purge_table('<your table name');

  select purge()