What developers find surprising about Postgres transactions


#developers #find #surprising #Postgres #transactions

What do you think?

12 Points
Upvote Downvote

One Comment

Leave a Reply
  1. Author here!

    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!

Leave a Reply