Pitfalls of Isolation Levels in Distributed Databases (planetscale.com) 2 points by sougou 5y ago ↗ HN
[–] PaulHoule 5y ago ↗ Weak article with numerous factual errors. SERIALIZABLE is much more feasible than they sayhttps://www.postgresql.org/docs/9.5/transaction-iso.htmland can be done w/o any locking or waiting -- you can keep track of which data transaction A has accessed and if transaction B commits that changes something A depends on you abort transaction A and the application can try it over.
1 comment
[ 49.9 ms ] story [ 416 ms ] threadhttps://www.postgresql.org/docs/9.5/transaction-iso.html
and can be done w/o any locking or waiting -- you can keep track of which data transaction A has accessed and if transaction B commits that changes something A depends on you abort transaction A and the application can try it over.