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

From David G. Johnston
Subject Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?
Date
Msg-id CAKFQuwYCj-gXZuyrwpP-jycbgH2_HmEsNWvJNDqr0WT2fEp8_A@mail.gmail.com
Whole thread Raw
In response to SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?  (이현진 <jemie9812@gmail.com>)
Responses Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?
List pgsql-general
On Sunday, March 30, 2025, 이현진 <jemie9812@gmail.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.


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.

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?
Next
From: Laurenz Albe
Date:
Subject: Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?