Re-engineering Postgres for Millions of Tenants (PGConf.dev 2025) скачать в хорошем качестве

Re-engineering Postgres for Millions of Tenants (PGConf.dev 2025)

Presented by Gwen Shapira at PGConf.dev 2025 (https://2025.pgconf.dev) Multi-tenant applications face the unique challenge of scaling along two dimensions: the number of tenants and the workload of each tenant. These applications must scale while maintaining consistent low latency and efficient resource utilization. Existing solutions range from giving each tenant its own database to consolidating all tenants within a single database, schema, and tables. The former offers flexibility and isolation at the expense of efficiency and engineering complexity, while the latter is efficient and simple but risks noisy-neighbor problems and data leaks. In this talk, I’ll share how Nile approached adapting Postgres for multi-tenant applications. We’ll share the overall architecture and dive into key decisions. We’ll share how leveraged existing Postgres capabilities and introduced a new purpose-built storage layer that allows us to isolate tenants and migrate them between Postgres instances in order to scale to millions of tenants. https://www.pgevents.ca/events/pgconf... 🎬 See more PGConf.dev 2025 videos at    • PGConf.dev 2025   Connect with us: LinkedIn:   / post   X   / pgconfdev   Mastodon: https://mastodon.social/@pgconfdev Bluesky: https://bsky.app/profile/pgconf.dev Web: https://pgconf.dev #postgresql #PGConfDev