[HACKERS] An isolation test for SERIALIZABLE READ ONLY DEFERRABLE

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема [HACKERS] An isolation test for SERIALIZABLE READ ONLY DEFERRABLE
Дата
Msg-id CAEepm=2Byq6_vi2WuXQPVQJTsCXB2Xd7-Pgq+zQncPy1E_Kyfg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] An isolation test for SERIALIZABLE READ ONLY DEFERRABLE  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hi hackers,

Here is a small patch to add a test exercising SERIALIZABLE READ ONLY
DEFERRABLE.  It shows a well known example of a serialisation anomaly
caused by a read-only transaction under REPEATABLE READ (snapshot
isolation), then shows the different ways that SERIALIZABLE and
SERIALIZABLE READ ONLY DEFERRABLE avoid the anomaly.

To be able to do this, the patch modifies the isolation tester so that
it recognises wait_event SafeSnapshot.

-- 
Thomas Munro
http://www.enterprisedb.com

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: [HACKERS] PoC: Make it possible to disallow WHERE-less UPDATEand DELETE
Следующее
От: Michael Meskes
Дата:
Сообщение: Re: [WIP] RE: [HACKERS] DECLARE STATEMENT setting up a connectionin ECPG