In case it's interesting to people, here's a blog post I made earlier this year on the topic of what exactly transaction isolation means:
Which, as far as production-common database implementations go, is lightspeed for implementing new academic work (9.1, the first version with the feature, was released in 2011).