TLDR DevOps · OPINIONS & TUTORIALS
SEQUENCES AND OTHER VOLATILES IN NEKI
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.