TLDR DevOps · OPINIONS & TUTORIALS

SEQUENCES AND OTHER VOLATILES IN NEKI

planetscale.com12 min read

Summary from the TLDR DevOps newsletter

Distributing PostgreSQL queries across shards gets complicated when functions depend on time or generate sequence values. Neki coordinates sequence allocation through its router and preserves how often expressions execute, preventing query optimizations from producing duplicate IDs or changing SQL behavior.