ancient history mark and rolling back data
Hello,
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?
Thanks!
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?
Thanks!
0
Comments
Please check...
http://p.tl/ln1Z
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.