[vbezhenar]

Yep, keep transaction open with necessary isolation. But it requires very thorough design of queries, as you'll run into locks pretty quickly. MVCC is not magic.

[twic]

Or using an Oracle style AS OF query:

https://oracle-base.com/articles/10g/flashback-query-10g