Supavisor: Scaling Postgres to 1 Million Connections

Supabase has developed Supavisor, a scalable, cloud-native Postgres connection pooler that can handle millions of connections. Built with multi-tenancy in mind and developed in Elixir, Supavisor is expected to enable new features for Postgres clusters such as query caching, automatic read-replica load balancing, and query blocking. The platform has been benchmarked under a million concurrent active connections, showing promising results for scalability and performance. Supavisor's impact on query duration was also measured, with median query durations less than 2ms in some tests. The new connection pooler is now rolled out to all Supabase projects across regions.