The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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 SET_AHM_NOW();
select purge();
SELECT DO_TM_TASK('mergeout');

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

Comments

Leave a Comment

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