Re: Transaction isolation level Repeatable Read Read Only vs Serializable Read Only

From: Mohamed Wael Khobalatte <mkhobalatte(at)grubhub(dot)com>
To: Jan Behrens <jbe-mlist(at)magnetkern(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Transaction isolation level Repeatable Read Read Only vs Serializable Read Only
Date: 2020-11-27 00:13:53
Message-ID: CABZeWdy44EOjvN5bm-gwg8UM0yv6pfLG6_jY7A_8E3_iXzJAMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> Thus, what does SERIALIZABLE READ ONLY achieve that REPEATABLE READ READ
> ONLY does not? And what is SERIALIZABLE READ ONLY DEFERRABLE for?
>

There is a nice walkthrough of the "control" and "batches/details" scenario
mentioned in the docs, you can find it in the wiki,
<https://wiki.postgresql.org/wiki/SSI#Deposit_Report> and I think it
explains the difference well.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Behrens 2020-11-27 01:19:11 Re: Transaction isolation level Repeatable Read Read Only vs Serializable Read Only
Previous Message Jan Behrens 2020-11-26 22:45:09 Transaction isolation level Repeatable Read Read Only vs Serializable Read Only