SQL Server's WITH (NOLOCK) equivalent in PostgreSQL? - Mailing list pgsql-general

From 이현진
Subject SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?
Date
Msg-id CAH0WOV4JhR3OgjNg69h-ZY9o1ooWq=32aa4GrSL5a3y41nApHQ@mail.gmail.com
Whole thread Raw
Responses Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?
Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?
List pgsql-general
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Querying one partition in a function takes locks on all partitions
Next
From: Christophe Pettus
Date:
Subject: Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?