4 ms·

It 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=12693127

• UK-AL 10y ago
  Just because it does it in tempdb, doesn't mean its not MVCC. That's an implementation detail.
  • serguzest 10y ago
    In postgres (and probably in others aswell), MVCC implemented in Btree storage level. there is an overhead to write tempdb.
    • anarazel 10y ago
      Btrees in postgres have no visibility information, MVCC is implemented on the heap level.