Starting with an simple ask in my daily business just to compare the performance of PostgreSQL DBaaS offerings between different cloud vendors I’ve opened a door into an unexpected journey of way more effort, research and thoughts.
However, achieving optimal performance from PostgreSQL requires a nuanced understanding of its behavior under different workloads. This talk chronicles an in-depth journey into PostgreSQL benchmarking, sharing lessons learned, unexpected challenges, and key insights gained along the way.
We will explore my methodology used to design and execute meaningful benchmarks, including the selection of tools, configuration tuning, and workload modeling that aligns with real-world scenarios. Key takeaways will include strategies for interpreting benchmark results, common pitfalls to avoid, and the impact of factors such as parametrization and compute configurations.
The session also dives into the evolution of benchmarking practices, addressing questions like: What distinguishes synthetic benchmarks from real-world performance measurements? How do version upgrades and new features affect benchmarking strategies?
Whether you are a database administrator, developer, or architect, this talk aims to equip you with practical insights and actionable techniques to master the art and science of PostgreSQL benchmarking, helping you unlock its full potential for your workloads.
Open source… What does that actually mean in real life? How do you turn a buzzword into something real that creates value and solves real problems? What does open source and the PostgreSQL database world mean for everyday life?
Picture this: you start a new role, eager to learn and contribute with your ideas! Your next task is to get familiar with the database setup, and then you start encountering these massive PostgreSQL databases — 100TB, 200TB, 300TB…
And you start questioning yourself: how do you backup (and restore) a +100TB database? And how about HA? Upgrades?
It should work the same way as for a 100GB database, right? Well, maybe not exactly.
When reading blog articles, the best practices, the “how-to” guides, things seem straightforward. But when you start bending PostgreSQL’s limits, you will end up needing to question the most fundamental assumptions about how PostgreSQL works.
Over the last years, my team at Adyen has been exploring the boundaries of what PostgreSQL can do, and today I will share our findings with you (at least the ones I can!).
An important performance optimization was added to Postgres 17, which changed the way SLRUs are managed and configured. But what are exactly these SLRUs? What do they store? What exactly was changed in Postgres 17? How do we now configure them? This talk goes over these questions in detail.
Data wants to stay where it is. Yet in modern applications, we continuously defy this with pipelines, streams, and staging layers. This talk questions that premise. Can we rethink locality and latency by inverting how data systems are composed? By treating the operational database as the source of truth and the query engine, we explore a pattern that eliminates redundancy, complexity, and delay. Real-world examples will illustrate the cost of unnecessary motion—and the gains when you stand still.
The integration of PostgreSQL within Kubernetes environments has historically been viewed with apprehension, reminiscent of past debates concerning databases on virtual machines. However, significant advancements have been made in both areas.
This keynote will provide an update on the current state of PostgreSQL integration within Kubernetes, highlighting the substantial progress that has occurred. We will introduce CYBERTEC Scalefield, a solution that establishes a new benchmark for PostgreSQL operations within Kubernetes, and offer a brief insight into its distinctive advantages for the PostgreSQL community.
This session explores how to integrate PostgreSQL and Flyway into CI/CD pipelines to enable safe, automated database deployments. Learn best practices for managing schema migrations, version-controlling your database, and synchronizing database changes with application releases. A practical guide to making database delivery a seamless part of your DevOps workflow.
