Re: Write skew observed under serializable isolation - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: Write skew observed under serializable isolation
Date
Msg-id CAJ7c6TNpThuh1C34GSBUuT=WcpSjM882wOWHQSgKojANQxJztw@mail.gmail.com
Whole thread
In response to Re: Write skew observed under serializable isolation  (Andrey Borodin <x4mmm@yandex-team.ru>)
Responses Re: Write skew observed under serializable isolation
List pgsql-hackers
Hi Andrey,

Thanks for the great feedback.

> > +# other one read.  No serial order produces sum(p) = 2, ...
>
> The constant assignments in this test produce a final sum of 2 in either
> serial order too. The anomaly is that both preceding reads return 0.
> Could we correct the comment? The test itself demonstrates the bug.

Good catch. Fixed.

> Maybe we could also cover inserts after scanning an initially empty
> table. That would guard against moving lock acquisition into a per-page
> path later: there are no existing pages to lock. Without the fix both
> transactions commit; with v2 one is aborted.

Agree. Added.

-- 
Best regards,
Aleksander Alekseev

Attachment

pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Re: Logical replication can lose an update after concurrent index invalidation
Next
From: Matthias van de Meent
Date:
Subject: Re: [PATCH] set_byte() with a count argument