Since PostgreSQL uses MVCC, I'm wondering what the best practice is for non-blocking reads,
and whether there's an equivalent to dirty reads or READ UNCOMMITTED.
We are unable to implement read uncommitted because of our choice to implement MVCC. There is no equivalent because the fundamental operating decisions doesn’t allow for one.
If you don’t pre-suppose the solution of dirty reads and instead supply a use case and desired constraints maybe an alternative approach for that use case could be suggested.
David J.
