Auto purge

ashu123ashu123 Registered User
edited May 18 in Vertica Forum

How to purge automatically when it reaches count to 1crore?


  • naresh_way2naresh_way2 Registered User

    I have the same problem what we do?

  • Jim_KnicelyJim_Knicely Employee, Registered User, VerticaExpert


    Are you asking how to purge a table when you have a row count of 10 million, or purge when you've deleted 10 million records, or something else? The question is a bit vague :/

  • ashu123ashu123 Registered User

    It should be automatically purged when deleted count reaches to 10 million across all tables, every time it should be less than 1 million

  • Jim_KnicelyJim_Knicely Employee, Registered User, VerticaExpert
    edited May 22

    Vertica provides two methods for determining when deleted data is eligible to be purged:

    1. Specifying the time for which delete data is saved
    2. Specifying the number of epochs that are saved

    If you want to purge based on delete vector row counts, you can set up a cron job that runs every so often that issues a purge command when the dv row counts >= 10 million.

Leave a Comment

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