Question: how mvcc works in postgresql?
Answer: How MVCC works. Every transaction in postgres gets a transaction ID called XID. ... For example, when you insert a row, postgres will store the XID in the row and call it xmin . Every row that has been committed and has an xmin that is less than the current transaction's XID is visible to the transaction.