Setting Data Retention in Vertica

anshulupadhyay

Hi,

I want to free up some disk space for which I want to delete the events from Vertica. How can we trigger a retention policy to delete some old data ?

Jim_Knicely

Hi,

Are you referring to the data collector tables?

See:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Monitoring/Vertica/RetainingMonitoringInformation.htm

You can configure their "Data Retention Policies".

See:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Monitoring/Vertica/ConfiguringDataRetentionPolicies.htm