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

What is the password of postgres user?

636


Provide a brief explanation of the functions in postgresql.

598


How are the stats updated in postgresql?

608


What is a postgres server?

594


What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?

1215


Where is postgresql conf?

623


What is the port 5432?

626


How do I add one column in postgresql?

589


What is maximum size of text datatype in postgres?

602


How to write sql script in postgresql?

579


What is pgadmin used for?

592


What language does postgresql use?

559


How to create local server in postgresql?

587


How do you check data on pgadmin 4?

572


What is serial data type in postgresql?

626