On Epochs

I have gone through the topic: Understanding Epoch in the document and in the community post. 

 

But still confused on- 

 

how the epoch (number) moves from CE -> LE - > CPE -> LGE -> AHM ? 

 

Experts, 

Could you please explain with an example how/when the epoch no moves form one to other. 

 

Thank you

Comments

  • Hi, The CE advance by a commit, every time that you do a ddl. Insert+ commit. delete + commit, copy ( it has auto commit) etc. LG advance when CE advance. CPE advance when the tuple mover move the data from WOS to ROS. LGE automatically advance with the CPE AHM is a service that runs based on a configuration parameter and by default it gets = LGE but you can setup configuration parameters to be xx epochs or xx Seconds from the LGE. Hope this helps, Eugenia

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.