You could instead put the global max seen id into every row, but then you would have to update all the rows on every transaction. Which is not great peformance-

You could instead put the global max seen id into every row, but then you would have to update all the rows on every transaction. Which is not great peformance-wise, but would also massively exacerbate the non-atomic sum problem downstream in total.