Per-user pools that share fairly
· 10 min read
Part 2 of a series. Start with Two jobs, two processes for the architecture and motivation.
Multigres maintains a separate connection pool per user. This post is about why we made that choice (it's mostly a security story), how we share the connection budget fairly across users, and the routing trick that keeps pool lookup constant time even when there are many pools.
