We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


I cannot purge deleted data manually and automatically — Vertica Forum

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