1.

What is Multi Version Concurrency Control in PostgreSQL?

Answer»

Multi-Version Concurrency Control (MVCC) is an advanced method used in PostgreSQL for improving the performance of a database in a multi-user environment. Unlike lock MODELS in other DATABASES, PostgreSQL uses a multi-version environment in which locks that are acquired for reading data don’t conflict with locks acquired for writing the data. HENCE, making the process more compartmentalized and a LOT faster.



Discussion

No Comment Found