Databases · Senior · Question 5 of 75
What does synchronous_commit = off trade away?
- 1Consistency of foreign keys
- 2The ability to use indexes
- ✓Correct answer: A crash may lose the last few committed transactions (but not corrupt data), in exchange for faster commits
Explanation
It can be set per transaction, e.g. for analytics events you can afford to lose, while payments keep full durability.