Setting Data Retention in Vertica

8 years ago
Oct 10, 2018 6:03 AM UTC
1 reply
8 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
8 years ago
Oct 10, 2018 12:28 PM UTC

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