Conference Schedule - PGConf NYC 2022

The I in ACID

Date: 2022-09-22
Time: 15:45–16:35
Room: The Innovation Space
Level: Advanced
Feedback: Leave feedback

Why talk about old things like ACID properties? We all know everything we need to know about that, right? Well, I found out that even though these properties were old, well known, and beautifully documented, it didn't mean people actually understood them. I found myself repeatedly explaining how it works, what tradeoffs were made, and why.

Particularly, transaction isolation and its anomalies were not commonly known and I found out developers adding extra layers in their applications instead of simply adjusting their database isolation level for that particular query.

After explaining globally ACID properties, we'll focus on transaction isolation, transaction isolation anomalies and in what case a developer should care about transaction isolation.


The following slides have been made available for this session:


Lætitia Avrot