4 ms·What about true MVCC?by serguzest 10y agoWhat about true MVCC?deleted 10y ago[deleted]UK-AL 10y agoREAD_COMMITTED_SNAPSHOT?serguzest 10y agoIt uses tempdb for tracking versions, it is not mvcc in the core https://news.ycombinator.com/item?id=12693127 https://news.ycombinator.com/item?id=12693127UK-AL 10y agoJust because it does it in tempdb, doesn't mean its not MVCC. That's an implementation detail.serguzest 10y agoIn postgres (and probably in others aswell), MVCC implemented in Btree storage level. there is an overhead to write tempdb.anarazel 10y agoBtrees in postgres have no visibility information, MVCC is implemented on the heap level.