Hi all,
I'm trying to understand how to replicate SQL Server's WITH (NOLOCK)
behavior in PostgreSQL.
Since PostgreSQL uses MVCC, I'm wondering what the best practice is for
non-blocking reads,
and whether there's an equivalent to dirty reads or READ UNCOMMITTED.
Would appreciate any insights or recommended approaches.