ancient history mark and rolling back data


From reading it seems historical data beyond the current epoch marker are eligible for purge and can never be recoverable..

What is the best approach for an organization who wants the ability to revert to a previous day or week's snapshot?  

Should they configure the AHM to advance on a daily or weekly basis (rather than the default value)?  Is that going to degrade the performance too much (too many delete vectors)?

Or, is there some other mechanism to recover previous snapshot in Vertica which is completely unrelated to the AHM marker?

Another question:  Can AHM related settings be confined to specific schemas?



  • Options
    How about using vbr.py script to backup and restore?
    Please check...

    If you backup with some restorepoints, you can restore at some points.

    Then, I don't think that there is any AMH related setting confined to specific schemas.

  • Options
    Thank you Kanako!

Leave a Comment

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