How to do get_or_insert_by in Ecto without race condition?

Questions & Help Questions
, ,
3

Do transaction in postgres actually lock the whole tables? I think it might depend on isolation levels, which is read committed, by default (I think), which I don’t think locks the tables but uses mvcc.