Put some light on multi-version concurrency control?
Answer / Sunil Kumar Gautam
Multi-Version Concurrency Control (MVCC) is a technique used by PostgreSQL to allow multiple transactions to access the database concurrently without blocking each other. MVCC allows each transaction to see a consistent snapshot of data, even if other transactions are modifying that data simultaneously. This is achieved by storing multiple versions of each row and keeping track of the transaction IDs that have modified the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a postgres server?
What is postgresql database cluster?
What are the data types in postgresql?
How do you check data on pgadmin 4?
What is varchar in postgresql?
How do I find the size of a postgres table?
How does pgadmin connect to database?
How to check dependency of table in postgresql?
What is serial data type in postgresql?
Is primary key indexed by default in postgres?
Where are postgres databases stored?
What is the port 5432?
Oracle (3253)
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)