InterviewSolution
Saved Bookmarks
| 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. |
|