4 docs tagged with "databases"

A reproducible PostgreSQL benchmark comparing an integer array with a GIN index against a conventional bridge table.

Consistent hashing is the backbone of many distributed systems. From caches and databases to load balancers and CDNs, it enables deterministic routing with minimal reshuffling when nodes change. Let’s explore the most common real-world use cases.

A personal reflection on how PostgreSQL became my go-to database — from early days dabbling with various db engines all the way to building Postgres from source and stepping through it with GDB.

Explaining the often-missed distinction between semantic and non-semantic partitioning, and how it applies across databases, caches, and even load balancing.