We are currently exploring esdb. I think we understand how checkpoints work from the perspective of a persistent subscription for example. But we are wondering how it works from the perspective of the server.
We’ve just appended around 630,000 events and the checkpoint for the last added event was 1,495,199,571. The current checkpoint is 3,208,058,305. We are running all system projections and no user defined projections.
Given the current checkpoint there is a 1:5,000 ratio between the current checkpoint and the number of events. So every event would cause the checkpoint to increase by at least 5,000. Does this make sense? Is this caused by running system projections?
Checkpoint is an unsigned long. Given the ratio this would allow storing 3,618,549,444,923,920 events. This of course is quite alot, but we are wondering why does the checkpoint value increase as fast as it does?
Anyone with some better insights then us on how checkpoints work?