What developers find surprising about Postgres transactions
blog.lawrencejones.dev
blog.lawrencejones.dev
Postgres runs at a different isolation level than similar databases like MySQL, which means transactions behave subtly differently.
This means experienced engineers can assume their past experience carries to Postgres, and may be working with an incorrect mental model. The same goes for people who learned transactions theoretically, who may assume Postgres gives you greater guarantees than it actually does.
This explanation has always surprised people- I hope people find it interesting!
Interesting explanation.
I just want to note that both Oracle and SQL Server use READ COMMITTED as default too, so most people get the same isolation level.
Anyway this is something that surprises most of juniors devs.