Database

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.

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.

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.