What do you understand by multi-version concurrency control?

1.	What do you understand by multi-version concurrency control?
Answer» MVCC or Multi-version concurrency control is USED for avoiding unnecessary database LOCKS when 2 or more requests tries to access or modify the data at the same TIME. This ENSURES that the time lag for a user to log in to the database is avoided. The transactions are RECORDED when anyone tries to access the content. For more information regarding this, you can refer here.

Answer»

MVCC or Multi-version concurrency control is USED for avoiding unnecessary database LOCKS when 2 or more requests tries to access or modify the data at the same TIME. This ENSURES that the time lag for a user to log in to the database is avoided. The transactions are RECORDED when anyone tries to access the content.

For more information regarding this, you can refer here.

Discussion

No Comment Found

Related InterviewSolutions

Differentiate between commit and checkpoint.
What are parallel queries in PostgreSQL?
Does PostgreSQL support full text search?
How will you take backup of the database in PostgreSQL?
How do you perform case-insensitive searches using regular expressions in PostgreSQL?
What is the main disadvantage of deleting data from an existing table using the DROP TABLE command?
What can you tell about WAL (Write Ahead Logging)?
How do you check the rows affected as part of previous transactions?
What do you understand by command enable-debug?
What do you understand by multi-version concurrency control?

What do you understand by multi-version concurrency control?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment