Marco Slot

POSETTE 2024 Talk

Data-intensive PostgreSQL: Three ways to scale

local CEST (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.