Blog

Technical writing on things I've learned building systems at scale: Postgres internals, .NET performance, data engineering patterns, and the occasional hard-won lesson.

How Postgres CTIDs Gave Me a 30x Speedup on Processing 200 Million Rows

Indexes don't solve everything at scale. How I went from 3-day process to a few hours by exploiting PostgreSQL's physical row addresses for cache-friendly sequential reads.

postgresqlperformancebig-datadotnet12 min read