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.
