Re:My Favorite PostgreSQL Queries and Why They Matter
by stubish on Thursday April 19, 2018 @08:49PM
(#16881358)
I suggest read committed, and increase it to serializable only if necessary. serializable transaction isolation means your code is responsible for catching the serialization exceptions that will occur and handling them (retrying the transaction, generally). Devs just don't do that, and don't even know how to trigger the exceptions in most case. So you end up with apps that work fine during CI and staging, but start failing under load. And it might not be possible to retrofit the correct exception handling without a massive re-architecture.
[ Parent
| on HN ]
There are no comments on this comment yet.