I'll check out mvcc. Would user defined locks on a specific table make PostgreSql underperform too much?
Thanks again,
Eudald
El vie., 24 abr. 2020 a las 18:15, Tom Lane (<tgl@sss.pgh.pa.us>) escribió:
Eudald Valcàrcel Lacasa <eudald.valcarcel@gmail.com> writes: > Could it be possible that, somehow, the select query starts before the > update one, although it's printed as if it's being executed after it?
It's certainly possible that the select is using a snapshot that was taken before the update commits. You should read this chapter of the manual for background and some hints:
