Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?

On Sunday, March 30, 2025, 이현진 <jemie9812(at)gmail(dot)com> wrote:

>
> 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.
>

https://www.postgresql.org/docs/current/transaction-iso.html

We are unable to implement read uncommitted because of our choice to
implement MVCC. There is no equivalent because the fundamental operating
decisions doesn’t allow for one.

If you don’t pre-suppose the solution of dirty reads and instead supply a
use case and desired constraints maybe an alternative approach for that use
case could be suggested.

David J.