Database

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.

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.

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.