Databases · Senior · Question 10 of 75
How does PostgreSQL implement the Serializable level?
- 1By locking every table read by the transaction
- ✓Correct answer: Serializable Snapshot Isolation: transactions run on snapshots, and dangerous read/write dependencies cause one of them to abort
- 3By running all transactions one after another on a single thread
Explanation
It doesn't block readers, but aborts are expected under contention, so the app must retry. Read-only deferrable transactions can avoid aborts entirely.