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 |
What is the option that can be used in PostgreSQL to find out how the query optimizer is evaluating the query given?
List some of the features of postgresql ?
What is the blob data type?
Does postgres create indexes for foreign keys?
How do you check data on pgadmin 4?
What is shared_buffers postgresql?
How the stats updated in postgresql?
How do you create a table in pgadmin 4?
How long does it take to create an index on a large table?
How do I start postgresql on windows?
What is a function in postgresql?
What is the password of postgres user?
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)