I cannot purge deleted data manually and automatically

I cannot purge deleted data manually and automatically.
I am using Vertica 8.1.0 and I delete unnecessary data periodically, but the storage does not being free after retention time.
When I try to purge deleted data manually, it does not work too.

My Setting:
HistoryRetentionTime = 1800 sec
HistoryRetentionEpochs = 0

My manual commands to purge data:
select purge();
SELECT DO_TM_TASK('mergeout');

How can I purge deleted data?
Thanks for any help or insight anyone can provide.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file