Data-intensive PostgreSQL: Three ways to scale | POSETTE 2024

Video of a conference talk about data-intensive PostgreSQL presented by Marco Slot at POSETTE: An Event for Postgres 2024. PostgreSQL is the most versatile data-processing tool available, and a safe choice for practically any type of application. However, as the data volume and velocity in your application grow, a variety of bottlenecks can appear. The type of bottleneck depends heavily on the workload, so there is not one answer to scaling PostgreSQL. This talk will discuss 3 data-intensive workload patterns: Growing SaaS app with a high transaction rate. Site-facing analytics dashboard with a high rate of real-time data. Interactive analytics on a high volume of recent and historical data. For each workload pattern, we'll discuss the main scalability challenges and key techniques for addressing them in PostgreSQL. Marco is building a new generation of PostgreSQL extensions at Crunchy Data. He previously led the development of several PostgreSQL extensions at Citus Data and Microsoft, including Citus and pg_cron. Chapters: 00:00 - Intro 02:40 - How to scale Postgres 05:51 - Multi-tenant SaaS applications 11:35 - User-facing time series dashboards 16:38 - Business intelligence 22:37 - Summary 📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist-2024 📌 Let’s connect: X – @PosetteConf https://x.com/PosetteConf Mastodon - @posetteconf https://mastodon.social/@posetteconf Threads – @posetteconf https://www.threads.net/@posetteconf 🔔 Subscribe to the POSETTE News: https://aka.ms/posette-subscribe 📣 Slides for this talk: https://1drv.ms/p/s!AvD4ymbRg63ZmnICA... #PosetteConf #PostgreSQL #Citus Presenters: Marco Slot, Software Imagineer at Crunchy Data Connect: Marco Slot:   / marcoslot  ,   / marcoslot