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 do you delete a row in a table?
How to import sql file in postgresql pgadmin 4?
How do I create a postgresql table using pgadmin?
How is data stored in postgresql?
Is postgres a sql database?
What is postgres xc?
Compare ‘postgresql’ with ‘nosql’?
Is mysql a postgresql?
Is postgres a database?
What is maximum size of table in postgresql?
What is multi-version control?
How do you change the name of a column?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)