Hacker News new | past | comments | ask | show | jobs | submit login
What developers find surprising about Postgres transactions (lawrencejones.dev)
5 points by lawrjone 50 days ago | hide | past | favorite | 2 comments

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!


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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact