We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


On Epochs — Vertica Forum

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