Explain the difference between READ COMMITTED and REPEATABLE READ.

Question

Randhir Jassal · Accepted Answer

READ COMMITTED takes a fresh snapshot per statement — non-repeatable reads are possible. REPEATABLE READ takes one snapshot at the start of the transaction; subsequent reads see the same data. Postgres REPEATABLE READ also prevents phantom rows.

Explain the difference between READ COMMITTED and REPEATABLE READ.

What is the saga pattern and when should you use it?

How do you handle distributed transactions without two-phase commit?

When does a Postgres index NOT get used?

Explain the difference between READ COMMITTED and REPEATABLE READ.

What is the saga pattern and when should you use it?

How do you handle distributed transactions without two-phase commit?

When does a Postgres index NOT get used?

Related questions

What is the saga pattern and when should you use it?

How do you handle distributed transactions without two-phase commit?

When does a Postgres index NOT get used?

Related questions

What is the saga pattern and when should you use it?

How do you handle distributed transactions without two-phase commit?

When does a Postgres index NOT get used?