Welcome to Distributed Bytes!

I share interesting articles, videos, papers and more about distributed systems, formal methods and computer science.

Made with by Federico Ponzi

Recent Posts

Smarter Auto-Scaling for ClickHouse: The Two-Window Approach

How ClickHouse Cloud's two-window recommender and target-tracking CPU algorithm cut scale-down latency from 30 hours to 3 hours while eliminating oscillations and reducing infrastructure costs.

Smarter Auto-Scaling for ClickHouse: The Two-Window Approach

pthorpe92.dev

I get a lot of emails from people asking me how they can begin to learn the vast world of databases, and whether they are far enough along on their programming journey to bother trying to start to learn this sub-genre of CS. This post is meant to be my authoritative answer to those questions... Sort of a database specific version of: this post about programming in general.

pthorpe92.dev

RocksDB development finds a CPU bug | RocksDB

This is the story of how a RocksDB unit test I added four years ago, a mini-stress test you might call it, revealed a novel hardware bug in a newer CPU. It w...

RocksDB development finds a CPU bug | RocksDB

Three Lenses on Coordination | Async Stream

Three Sets of Specs (for Staying in Spec) In the last post I talked about how systems formalisms are like sculpting with a chisel: we remove behaviors we don’t…

Three Lenses on Coordination | Async Stream

Consensus Board Game

I have an early adulthood trauma from struggling to understand consensus amidst a myriad of poor explanations. I am overcompensating for that by adding my own attempts to the fray. Today, I want to draw a series of pictures which could be helpful. You can see this post as a set of missing illustrations for Notes on Paxos, or, alternatively, you can view that post as a more formal narrative counter-part for the present one.

Consensus Board Game

the mathematics of compression in database systems

why compression is (almost) always worthwhile

the mathematics of compression in database systems

Formal Methods Beyond Correctness: Isolation & Permissiveness of Distributed Transactions in MongoDB | MongoDB

Learn how we used modular protocol specification for verifying both correctness and performance of MongoDB’s distributed transactions protocol.

Formal Methods Beyond Correctness: Isolation & Permissiveness of Distributed Transactions in MongoDB | MongoDB

One-off Verified Transpilation with Claude

We can automatically check correctness properties of a TLA+ specification using TLC, a model checker that will exhaustively explore a spec’s reachable states...

One-off Verified Transpilation with Claude

Scaling PostgreSQL

How OpenAI scales PostgreSQL

Scaling PostgreSQL

Scaling PostgreSQL to power 800 million ChatGPT users

For years, PostgreSQL has been one of the most critical, under-the-hood data systems powering core products like ChatGPT and OpenAI’s API. As our user base grows rapidly, the demands on our databases have increased exponentially, too. Over the past year, our PostgreSQL load has grown by more than 10x, and it continues to rise quickly.

Scaling PostgreSQL to power 800 million ChatGPT users