[elsurudo]

Makes sense, but I can't help but feel it's a solution at the wrong abstraction level. It's a shame the DB can't figure this out for you.

[yccs27]

Yeah, it seems like it would be possible for the DB engine to aggregate all these increments into one update. If you have two increments by one each in the queue, why not make it a single increment by two? I'm not sure though how much computing power it would need to figure that out...

[LesZedCB]

wouldn't that break the atomic and isolated rule of ACID?

[samatman]

Not necessarily. If both updates are in a single transaction then it's valid for the query planner to batch them, although that seems unlikely in the use case this table layout is designed for.

[MauranKilom]

Not any more than the slotted counter pattern...

[LesZedCB]

how does the shape of data impact the storage applications safety contract?

[cryptonector]

The DB could figure it out IF it had monoid counter type to use as the column's type.