2 ms·
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
by vbezhenar 4y ago
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 4y agoOr using an Oracle style AS OF query: https://oracle-base.com/articles/10g/flashback-query-10g https://oracle-base.com/articles/10g/flashback-query-10g