Six months in, p_future holds 800M rows because the growth projection didn’t survive the workload, and every ALTER to fix it needs a maintenance window nobody wants to schedule. The boundary management is two lines of DDL; the harder part is picking a partition key that doesn’t leak into application code.

is CORS a browser security measure or a server security measure?

Given an array of data, what is the slowest way to sum up the integers? Is it adding the numbers from left to right, adding them randomly, or doing something else? In this post, we are going to build a data access pattern from the ground up that sums numbers as slowly as possible by exploiting memory pitfalls.

In this video we learn the basics of I/O devices, and how the interact with the the CPU in general purpose systems.

A look at how Linux handles system calls on x86-64, why crossing into the kernel has a cost, and why that cost shows up in performance profiles.

How Zalando built an in-process client-side load balancer for a million requests per second of internal fan-out traffic, what we layered on top (N-ring fade-in, occupancy-based bounded load, and AZ-aware routing with a latency health factor), and how hardening that path cut cost and made the service resilient to the infrastructure underneath it.

Have you ever come into some awaful situation where you run kill on a postgres process that handle a connection and then suddenly the whole Postgres restart, even though you just kill a single process that handle one connection. This post explains that.

Let’s be clear. It’s going to be a long time before running a local LLM will produce the type of results that you can get from querying ChatGPT or Claude. However, self hosted is useful when privacy is critical or when response time is not important.