Re: Queries getting older values (autocommit enabled)

Hello!
Thanks David and Tom for your answer.
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(at)sss(dot)pgh(dot)pa(dot)us>) escribió:

> =?UTF-8?Q?Eudald_Valc=C3=A0rcel_Lacasa?= <eudald(dot)valcarcel(at)gmail(dot)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:
>
> https://www.postgresql.org/docs/current/mvcc.html
>
> regards, tom lane
>