zlacker

[return to "The part of Postgres we hate the most: Multi-version concurrency control"]
1. jasonh+vy1[view] [source] 2023-04-27 03:23:11
>>andren+(OP)
IMHO part of the issue is that Postgres was built on the assumption that snapshot isolation would be widely used. I don't think this has proven to be the case.

Snapshot isolation isn't as robust and straightforward as strict serializability, but it also isn't as performant as READ COMMITTED. It seems like the worst of both worlds.

◧◩
2. int_19+sg4[view] [source] 2023-04-27 19:30:26
>>jasonh+vy1
IMO the best thing about snapshot isolation is that it's conceptually easy to understand and reason about.
[go to top]