Hi Zsolt,
> That's a way to fix it, but I am not sure that it is the proper way to
> do it because it locks way more than needed.
>
> [...]
This looks like the same concern Matthias expressed above.
Let's be mindful of the fact that SIREAD locks despite the name are
not actually locks. Also our SERIALIZABLE implementation allows
false-positives by design [1].
Perhaps there is a smart way of minimizing false positives but
personally I don't instantly see them. Firstly we should fix the
broken feature and optimizations can be discussed as a separate patch.
Users concerned with rollbacks can always choose other isolation
levels.
[1]: https://arxiv.org/abs/1208.4179
--
Best regards,
Aleksander Alekseev
