Setting Data Retention in Vertica

Forum|Forum|7 years ago
October 10, 2018
1 reply
5 views

anshulupadhyay
New Participant

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 ?

Forum|alt.badge.img

+2

Jim_Knicely
Participating Frequently
Forum|Forum|7 years ago
October 10, 2018

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

Like