/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 newvick.com
Why understanding B-trees will help you improve database performance Newvick's blog
| | akorotkov.github.io
ALTER INDEX ... SET STATISTICS ...? - Alexander Korotkov's blog
2.5 parsecs away

Travel
| | [AI summary] A technical deep dive into PostgreSQL's statistics gathering for indexed expressions and a workaround to improve query planning accuracy for complex expressions.
| | benjamincongdon.me
B-Trees: More Than I Thought I'd Want to Know | Ben Congdon
2.4 parsecs away

Travel
| | B-Trees are not boring, after all
| | abuisman.com
Simple query optimisation | ABuisman.com
2.0 parsecs away

Travel
| | Blog about solving problems with code, mostly Ruby, and other things I have learned working as an engineer and a technical leader
| | surfingcomplexity.blog
Extending MVCC to be serializable, in TLA+ - Surfing Complexity
16.5 parsecs away

Travel
| In the previous blog post, we saw how a transaction isolation strategy built on multi-version concurrency control (MVCC) does not implement the serializable isolation level. Instead, it implements a weaker isolation level called snapshot isolation. In this post, I'll discuss how that MVCC model can be extended in order to achieve serializability, based on work...