Optimization tales with CockroachDB: the slow logout (part 2)

This article is part 2 of a series on optimizing SQL queries in CockroachDB. It investigates a slow logout endpoint where a simple UPDATE statement on a sessions table causes thousands of retries and high latency. The author explains the root cause (ReadWithinUncertaintyIntervalError due to concurrent writes) and presents two optimizations: conditional writes and using read committed isolation. The article includes detailed analysis, code examples, and final performance results, making it highly relevant for developers working with CockroachDB or distributed SQL databases.