Database
4 posts
Stop Blaming Your Database — It's Your Pagination That's Slow
Database queries getting slower as users scroll deeper? OFFSET pagination is the culprit more often than not. Here’s why and what to do about it.
PostgreSQL 18 Asynchronous IO Revolution: Why This Is the Biggest Database Update in 5 Years
PostgreSQL 18’s asynchronous IO with io_uring delivers 3.4x faster sequential scans, 2.1x faster index scans. Real benchmark data, configuration guide, and migration strategy for the database performance revolution.
Go + sqlc + Postgres: The Zero-ORM Stack Behind Cloudflare's 99.99% Uptime
Cloudflare runs Go + sqlc + Postgres in production, bypassing GORM’s N+1 queries and reflection overhead. 85K vs 42K qps, p99 drops from 3.8ms to 1.2ms. Breaking down the design logic, migration patterns, and when it actually makes sense to switch.
PostgreSQL Query Parsing Too Slow? PgDog Ditched Protobuf and Got 5x Faster
PgDog is a Rust-based PostgreSQL proxy. They discovered Protobuf serialization was the real bottleneck in SQL query parsing — not the Postgres parser itself. By replacing Protobuf with direct C-to-Rust FFI bindings, they achieved 5-10x faster parsing.
