All Questions
Tagged with serialization concurrency
3
questions
6
votes
1answer
117 views
Does timestamp protocol following thomas's write rule allow non-view-serializable schedules in some cases?
I have come across the following line in a text book (Database System Concepts
Textbook by Avi Silberschatz, Henry F. Korth, and S. Sudarshan $6e$) page no. 686:
Thomas’ write rule allows schedules ...
1
vote
1answer
429 views
PostgreSQL visibility of records changes from other transaction inside the current one
I have a table "tst" which has a "status" column using which we process records in that table.
Once the records are processed we set the status to 'Y';
#\d tst
Table "core.tst"
...
35
votes
5answers
22k views
Locking issue with concurrent DELETE / INSERT in PostgreSQL
This is pretty simple, but I'm baffled by what PG does (v9.0).
We start with a simple table:
CREATE TABLE test (id INT PRIMARY KEY);
and a few rows:
INSERT INTO TEST VALUES (1);
INSERT INTO TEST ...
