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 |
Explain about indices of PostgreSQL?
Is postgres is free?
What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?
How do you create a table in pgadmin 4?
What is composite primary key?
Is postgresql a programming language?
Is postgresql the same as mysql?
Are foreign key constraints necessary?
Do indexes speed up queries?
What is max pool size?
What is difference between drop and delete?
What is connection pooling in postgresql?
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)