Explain about Multi version concurrency control?

Answer Posted / madhub

Multi version concurrency control or MVCC is used to avoid unnecessary locking of the database. This removes the time lag for the user to log into his database. This feature or time lag occurs when some one else is on the content. All the transactions are kept as a record.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to execute a function in postgresql?

460


What is the advantage of postgresql?

401


How do you delete a row in a table?

405


How do I connect to postgresql remotely?

405


What is performance_schema?

417






What is dual table in postgresql?

414


What is write ahead logging in postgresql?

457


How do I add a primary key in pgadmin?

423


How do I change the order of columns in postgresql?

437


What is a postgresql schema?

406


What is postgresql? Explain the history of postgresql.

438


How to get month wise data in postgresql?

406


Is postgresql cloud based?

389


What happens to index when table is dropped?

451


How do I connect to a postgresql database?

420