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

From the creator

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

Published 2024-06-13 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.