Pg isolation levels: 3 or 2?

From: Thalis Kalfigkopoulos <tkalfigo(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Pg isolation levels: 3 or 2?
Date: 2012-11-03 23:10:47
Message-ID: CAEkCx9FZqCcrHZ=2YgM2hu+-tTzMrVXij2NCycgsabdcJyc_FQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
PostgreSQLimplementation 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thalis Kalfigkopoulos 2012-11-03 23:32:11 Re: Server to run Postgresql
Previous Message Bob Pawley 2012-11-03 23:08:59 Server to run Postgresql