Conversation

Franck Pachot

@FranckPachot

Jul 13, 2021

I would love to know if, in real life, you keep the READ COMMITTED default in

@PostgreSQL

isolation level, or not. And if you do, here is a new blog post about READ COMMITTED anomalies in PostgreSQL

dev.to

READ COMMITTED anomalies in PostgreSQL

In my early days, I've been working with DB2 where we were thinking about the isolation level for...

Replying to

and

I am curious too. When PG users don't use RC do they choose RR or SSI?

Replying to

and

I assume it's mostly SSI. It's relatively hard for a nonexpert to understand the difference between SSI and RR, especially if they need a practical explanation for dev team. Makes sense as a conservative approach IMV.

12:19 AM · Jul 14, 2021Twitter Web App

Replying to

I think that the best arguments in favor of true SERIALIZABLE (be it strict 2PL, SSI, whatever) are all defensive/conservative arguments. Nothing wrong with that, of course.

Replying to

SSI by default, RR if predicate locks are a problem, RC for high volume updates that can behave pathologically when they all are retrying due to conflicts.

Show replies