PostgreSQL has become the go-to database for modern applications, but scaling beyond a single instance remains a hard problem. Multigres is an open-source project from Supabase that brings horizontal scalability and high availability to PostgreSQL by adapting the proven architecture of Vitess, the sharding system that came out of YouTube and now powers some of the world's largest MySQL deployments.
This talk covers how Multigres works: a two-level proxy architecture that presents a distributed cluster as a single Postgres server, intelligent query routing and connection pooling, and an orchestrator that handles failover automatically using unmodified PostgreSQL. Whether you're hitting the limits of a single instance today or planning ahead, you'll leave with a clear picture of where PostgreSQL scaling is headed.
Pizza is provided, and we also have a user group lending library of books & papers related to Postgres and Databases.
===== Speaker:
Peter Soderberg is a Customer Solutions Architect at Supabase helping users get the most out of Postgres and the ecosystem. He brings over a decade of field engineering experience, from large-scale analytics in Hadoop-land to real-time query engines on TB-per-hour+ Kafka streams. Prior to Supabase, he worked at Imply (Apache Druid) and Elastic helping organizations wrangle high-throughput pipelines, lightning-fast queries, and complex migrations. Peter lives in NW Seattle and has been a regular face at SEAPUG.
