PostgreSQL

PostgreSQL 18 brings native UUIDv7 support with 50% index performance improvement. Say goodbye to UUIDv4 fragmentation and get primary keys that are both ordered and unique.

AI agents can reason, plan, and converse—but forget everything once the session ends. The Ghost project solves this with a pure PostgreSQL-based infrastructure, turning the database into the agent’s memory palace.

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’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.