3 ms·

Snapshot is good enough. And then do all your related table changes in a single atomic txn and you’re good

• aphyr 3y ago
  That depends! As the article discusses, snapshot allows anomalies--like write skew--which might violate application invariants. Depends on your workload.
  • gigatexal 3y ago
    Oh right OLTP stuff in that case I’m a bit rusty there. Most everything I do is on the OLAP side.