Imagine you wrote a program for a pleasingly parallel problem, where each thread does its own independent piece of work, and the threads don’t need to coordinate except joining the results at the end. Obviously you’d expect the more cores it runs on, the faster it is. You benchmark it on a laptop first and indeed you find out it scales nearly perfectly on all of the 4 available cores. Then you run it on a big, fancy, multiprocessor machine, and it sank.

Crunch Data hosts many postgres instance as a cloud offering. While onboarding customer after customer this year they’ve noted a few key things everyone should put in place right away - to either improve the health of your database or to save yourself from a bad day

Skyscanner team accidentally submitted an incorrect change to the templating of infrastructure provisioning system. This deleted all of the microservices responsible for serving skyscanner.net and data to mobile app from the underlying infrastructure across the entire globe, causing a four-hour outage

Over the past few years, I’ve interviewed with a dozen or so companies and have completed ~50 or so individual algorithm problems. I’m frequently given feedback that I did a great job at the algorithms problem. In this post, I’m going to share how exactly I approach algorithm problems.

You don’t understand something until you sit down and write it yourself. When removing all extra functionality, and focus on a minimun level, what make a blockchain? Example, a key-value store can just be a Hashmap, as its core. What information a block hold? how they connect?

Steps to troubleshot and recover data once you don’t have backup, and many files of Postgres are corrupted. Query to select throw error could not read block 912 in file “base/16504/278344”: read only 0 of 8192 bytes.

Modern hardware has many instruction that help with JSON parsing such as AVX2 and SIMD. In this post, we will see how Flare deserializes JSON documents stored on disk using a very fast bespoke, sparse, vectorized deserializer. It’s Rust but the though process can be applied to any field