Skip to content

Topic

Postgres sharding

Splitting a Postgres database across many instances by a shard key, with the routing, scatter-gather and cross-shard join problems that follow.

Current clusters

build1 publisher

Neki's router plans the shard before Postgres plans the query

Neki puts a fleet of connection-owning routers in front of sharded Postgres, each emitting a topology plan you can read with EXPLAIN (NEKI_PLAN). Sessions live on the router holding them, so losing one is visible to the client.

Publishers:dev.to

Reality

Evidence45
Adoption
Insufficient
Hype gap+15
Incentives80
Confidence55