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

Поиск
Список
Период
Сортировка
От 이현진
Тема SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?
Дата
Msg-id CAH0WOV4JhR3OgjNg69h-ZY9o1ooWq=32aa4GrSL5a3y41nApHQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?
Re: SQL Server's WITH (NOLOCK) equivalent in PostgreSQL?
Список 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 по дате отправления: