Pg isolation levels: 3 or 2?

Поиск
Список
Период
Сортировка
От Thalis Kalfigkopoulos
Тема Pg isolation levels: 3 or 2?
Дата
Msg-id CAEkCx9FZqCcrHZ=2YgM2hu+-tTzMrVXij2NCycgsabdcJyc_FQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Pg isolation levels: 3 or 2?  (Peter Geoghegan <peter@2ndquadrant.com>)
Список pgsql-general
Hi all.

From the current docs (Ch.13 on Concurreny Control):

"In PostgreSQL, you can request any of the four standard transaction isolation levels. But internally, there are only three distinct isolation levels, which correspond to the levels Read Committed, Repeatable Read, and Serializable. When you select the level Read Uncommitted you really get Read Committed, and phantom reads are not possible in the PostgreSQL implementation of Repeatable Read, so the actual isolation level might be stricter than what you select."

How is that three levels and not two? Read Uncommitted and Read Commited are the same. And Repeatable Reads don't allow phantom reads thus making them effectively the same as Serializable. No?

TIA,
Thalis K.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Bob Pawley"
Дата:
Сообщение: Server to run Postgresql
Следующее
От: Thalis Kalfigkopoulos
Дата:
Сообщение: Re: Server to run Postgresql