Pg isolation levels: 3 or 2? - Mailing list pgsql-general

From Thalis Kalfigkopoulos
Subject Pg isolation levels: 3 or 2?
Date
Msg-id CAEkCx9FZqCcrHZ=2YgM2hu+-tTzMrVXij2NCycgsabdcJyc_FQ@mail.gmail.com
Whole thread Raw
Responses Re: Pg isolation levels: 3 or 2?  (Peter Geoghegan <peter@2ndquadrant.com>)
List 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 by date:

Previous
From: "Bob Pawley"
Date:
Subject: Server to run Postgresql
Next
From: Thalis Kalfigkopoulos
Date:
Subject: Re: Server to run Postgresql