Skip navigation

Speaker:

Marco Slot

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

(Livestream 2)

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.

View the slides


Past Talks

The Distributed PostgreSQL problem & how Citus solves it (Citus Con 2023)

Citus 11: A look at the Elicorn's horn (Citus Con 2022)


Podcast Appearances

My Journey into Performance Benchmarking with Jelte Fennema-Nio & Marco Slot

Working in public on open source with Simon Willison & Marco Slot

The Postgres team at Microsoft is proud to be the organizer of POSETTE: An Event for Postgres (formerly Citus Con).