What is a Neki router?
Written by Andres Taylor, Harshit Gangal, Ahmed Darwich The core challenge in operating a sharded database is deciding which shard(s) should execute a query. Each query passes through two plans. The Neki router builds the first plan using the data topology to decide which shard(s) receive the work and how results from multiple shards should be handled. Postgres then builds the plan you already know how to read, which decides how each selected shard executes its work. One of Postgres's fundament…