Explain about Multi version concurrency control?
Answer / 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 |
How to start, stop and restart postgresql database?
Provide an explanation about write ahead logging?
Is foreign key should be unique?
Who invented postgresql?
Why is pgadmin used?
How do you change columns in postgresql?
Which is better mysql or postgresql?
How do you insert rows and columns?
What is foreign key in postgresql?
What is character varying in postgres?
Explain what is PostgreSQL?
What is the command enable-debug?