Optimization tales in production with CockroachDB: UUID generation (part 5)
CockroachDB optimization: how UUID v4 generation causes cross-region reads and a simple fix yields 50x speed-up.
CockroachDB optimization: how UUID v4 generation causes cross-region reads and a simple fix yields 50x speed-up.
Optimizing a slow CockroachDB query listing users with SELECT DISTINCT, investigating performance issues.
Investigating and fixing a slow CockroachDB pagination query that reads millions of rows but only returns 100.
A technical deep dive into optimizing a slow SQL logout query in CockroachDB, reducing retries and improving performance.
Optimizing a slow password reset query in CockroachDB, reducing row reads from 700k to 10.
Analysis of CockroachDB's scalable leader lease protocol for multi-consensus groups, addressing failover and liveness issues.