Supavisor: A Postgres Connection Pooler for Huge Scale

Supavisor is a new cloud-native Postgres connection pooler that can support millions of connections. Developed with multi-tenancy in mind, Supavisor is built in Elixir and designed for large-scale operations. It aims to resolve the issue with Postgres's connection system, which can be memory-intensive and challenging to scale. Traditional connection poolers like pgbouncer are limited in their ability to scale, leading to the development of Supavisor. The team benchmarked Supavisor, demonstrating its capability to handle 1 million connections with a query caching, auto load balancing, and query blocking, without substantial overhead or latency. Tests included vertical and horizontal scaling scenarios, with Supavisor showing impressive stability and the ability to evenly spread the load across all cores. Preparing for wide deployment, Supavisor is set to roll out across the Supabase platform and is ready for use by projects demanding massive connection capabilities.