Blog Post

Database Concurrency: MVCC in PostgreSQL vs Row Versioning in SQL Server

,

What is Concurrency in Databases? Concurrency control ensures that multiple transactions can occur simultaneously without leading to data inconsistency. Two popular concurrency control mechanisms are: MVCC in PostgreSQL PostgreSQL uses MVCC to handle concurrent transactions without locking rows for reads. Instead of overwriting data, it creates a new version of a row for every update. … Continue reading

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating