Скачать или смотреть 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