Hacker News new | ask | show | jobs
by LesZedCB 1411 days ago
wouldn't that break the atomic and isolated rule of ACID?
2 comments

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.
Not any more than the slotted counter pattern...
how does the shape of data impact the storage applications safety contract?