Database Isolation Levels, Data Issues, and Global Transaction Consistency
Channel: Postgres Conference
Date: 2021-07-30

Dirty reads, phantom reads, write skew, ACID rain? These are all data concerns that are often overlooked, but can be very troubling and super expensive. Are you familiar with database isolation levels and how they can impact these data integrity?

In this session, we walk through a definition of these potential data issues and then map them talk about database isolation levels. We will then speak to how CockroachDB delivers serializable isolation in a distributed environment to ensure these issues won’t plague your application. We will cover...

Common data consistency issues
Transaction isolation levels
Application best practices for retries
Transactions in a distributed environment
CockroachDB and PostgreSQL compatibility