Tux Machines

Supavisor: Scaling Postgres to 1 Million Connections

Posted by Roy Schestowitz on Aug 14, 2023

Linux Devices and Open Hardware

Programming Leftovers

One of the most widely-discussed shortcomings of Postgres is its connection system. Every Postgres connection has a reasonably high memory footprint, and determining the maximum number of connections your database can handle is a bit of an art.

A common solution is connection pooling. Supabase currently offers pgbouncer which is single-threaded, making it difficult to scale. We've seen some novel ways to scale pgbouncer, but we have a few other goals in mind for our platform.

And so we've built Supavisor, a Postgres connection pooler that can handle millions of connections.

Read on

↺ Read On: Supabase Inc

gemini.tuxmachines.org