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

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