Understand concurrency in PostgreSQL

Intermediate
Database Administrator
Database for PostgreSQL

Azure Database for PostgreSQL is a multi-user relational database solution. The increase in users brings a risk of conflicts and so it is important to understand the concurrency systems that are in place.

Learning objectives

After completing this module, you'll be able to:

  • Describe Multi-Version Content Control and snapshots in Azure Database for PostgreSQL.
  • Describe isolation levels in Azure Database for PostgreSQL.
  • Describe locking in Azure Database for PostgreSQL.

Prerequisites

  • Demonstrate an understanding of relational databases.
  • Demonstrate an understanding of basic SQL.