POSETTE 2024 is a wrap! Missed it? Watch all 42 talks
Speaker:
Marco Slot
Software Imagineer at Crunchy Data
Marco Slot 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.
POSETTE 2024 Talk
Data-intensive PostgreSQL: Three ways to scale
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.
Past Talks
The Distributed PostgreSQL problem & how Citus solves it (Citus Con 2023)
- Video: Watch the talk on YouTube
Citus 11: A look at the Elicorn's horn (Citus Con 2022)
- Video: Watch the talk on YouTube
Podcast Appearances
My Journey into Performance Benchmarking with Jelte Fennema-Nio & Marco Slot
- Podcast episode: Listen on Transistor.fm
Working in public on open source with Simon Willison & Marco Slot
- Podcast episode: Listen on Transistor.fm
Subscribe to notifications to keep up with POSETTE news
Join the conversation
Use the hashtag #PosetteConf
The Postgres team at Microsoft is proud to be the organizer of POSETTE: An Event for Postgres (formerly Citus Con).
Citus Data is now part of 
©2024 Citus Data, a Microsoft Company. All rights reserved.
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.