PostgreSQL Interview Question:

Explain about concurreny with the help of MVCC?

Submitted by: Administrator

Multi version concurrency control is used to manage concurrency. This feature is very useful because changes made in the database will not be visible to other users until the transaction is completed. This removes the need for read locks. ACID principles are given a further boost by this feature and can be implemented in general.
Submitted by: Administrator