What Is Multi Version Concurrency Control in Postgresql

Multi-Version Concurrency Control (MVCC) is an advanced technique for improving database performance in a multi-user environment. Vadim Mikheev (<[email protected]>) provided the implementation for Postgres.

What is multi version control in PostgreSQL?

Multi-Version Concurrency Control (MVCC) is an advanced technique for improving database performance in a multi-user environment. Vadim Mikheev (<[email protected]>) provided the implementation for Postgres.

What is Multi Version Concurrency Control MVCC feature?

Multiversion Concurrency Control (MVCC) MVCC provides concurrent access to the database without locking the data. This feature improves the performance of database applications in a multiuser environment. Applications will no longer hang because a read cannot acquire a lock.