Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] An isolation test for SERIALIZABLE READ ONLY DEFERRABLE - Mailing list pgsql-hackers

From Thomas Munro
Subject [HACKERS] An isolation test for SERIALIZABLE READ ONLY DEFERRABLE
Date
Msg-id CAEepm=2Byq6_vi2WuXQPVQJTsCXB2Xd7-Pgq+zQncPy1E_Kyfg@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] An isolation test for SERIALIZABLE READ ONLY DEFERRABLE  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: [HACKERS] PoC: Make it possible to disallow WHERE-less UPDATEand DELETE
Next
From: Michael Meskes
Date:
Subject: Re: [WIP] RE: [HACKERS] DECLARE STATEMENT setting up a connectionin ECPG