Put some light on multi-version concurrency control?



Put some light on multi-version concurrency control?..

Answer / Sunil Kumar Gautam

Multi-Version Concurrency Control (MVCC) is a technique used by PostgreSQL to allow multiple transactions to access the database concurrently without blocking each other. MVCC allows each transaction to see a consistent snapshot of data, even if other transactions are modifying that data simultaneously. This is achieved by storing multiple versions of each row and keeping track of the transaction IDs that have modified the data.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Postgre Interview Questions

What is a postgres server?

1 Answers  


What is postgresql database cluster?

1 Answers  


What are the data types in postgresql?

1 Answers  


How do you check data on pgadmin 4?

1 Answers  


What is varchar in postgresql?

1 Answers  


How do I find the size of a postgres table?

1 Answers  


How does pgadmin connect to database?

1 Answers  


How to check dependency of table in postgresql?

1 Answers  


What is serial data type in postgresql?

1 Answers  


Is primary key indexed by default in postgres?

1 Answers  


Where are postgres databases stored?

1 Answers  


What is the port 5432?

1 Answers  


Categories