Four databases. One arena. Expect chaos, comedy, and questionable benchmarking as PostgreSQL takes on the rest in this live, totally biased battle for DB supremacy.
Thursday, September 4 at 17:40 – 18:05
Room: Orangerie
Room: Orangerie
Thursday, September 4 at 18:10 – 19:30
Room: Orangerie
Networking/Get Together time
Thursday, September 4 at 17:35 – 17:40
Room: Orangerie
Closing
Thursday, September 4 at 17:05 – 17:35
Room: Orangerie
Lightning Talks
Thursday, September 4 at 16:15 – 17:00
Room: Orangerie
Postgres with many data: To MAXINT and beyond
Picking up the topic of previous talks about using PostgreSQL to store many data, very many data, and absurdly many data, this talk wants to talk about the problems and challenges that one might experience when trying to shove all the data into PostgreSQL.
Many things that are simple with small amounts of data can become headache-inducing.
As data grows even a simple ‘select count(*)’ can be unpleasantly slow.
Taking a naive backup could easily take more than a day, and restoring such a backup is similarly time-consuming.
We will explore the limits of where PostgreSQL can go, the limits imposed by physics, hardware, and software, and ideas how we can go beyond those limitations.
We’ll also look at some performance problems and the many strategies we have to mitigate them.
Hopefully this talk will give you the confidence that PostgreSQL can grow with your data, and show you some of the options you have to improve performance when your data just keeps growing and growing.
Thursday, September 4 at 15:00 – 15:45
Room: Orangerie
Fun with Postgres High Availability Poker
Understanding all the details of a High Availability PostgreSQL clusters is one of the most critical DBA knowledge area’s.
Instead of boring you with endless numbers of slides, with volunteer assistance from the audience, we will show you all important concepts like WAL transport, synch/async commit, RTO, RPO, network involvement etc with nothing more than a few decks of playing cards and some funny hats.Understanding all the details of a High Availability PostgreSQL clusters is one of the most critical DBA knowledge area’s.
Thursday, September 4 at 14:10 – 14:55
Room: Orangerie
CloudNativePG 101
CloudNativePG brings a native, Kubernetes-friendly approach to managing PostgreSQL databases in cloud-native environments, which fills a critical gap in the CNCF ecosystem. CloudNativePG offers seamless integration with Kubernetes to manage its lifecycle, including high availability, disaster recovery, and backup/restore functionalities.
The talk is an introduction on features and behaviours of CloudNativePG, the Kubernetes operator that covers the full lifecycle of a highly available PostgreSQL database cluster with a primary/standby architecture, using native streaming replication.
Discussed topics are:
– the operator CRD
– operand images and extensibility
– suggested architectures
– deployment (helm, manifest application…)
– monitoring (Prometheus metrics)
– most recent features, like volume snapshot backups/restore and declarative databases, publicatoins, subscriptions
Website: https://cloudnative-pg.io/
Thursday, September 4 at 09:10 – 09:25
Room: Orangerie
Keynote- Empowering PostgreSQL Teams with Redgate’s End-to-End Database Solutions
Discover how Redgate is extending its trusted, end-to-end database solutions to support PostgreSQL teams. In this keynote, we’ll introduce Redgate and highlight our newest PostgreSQL-focused solutions that help development, operations, and data teams streamline workflows, improve performance, and safeguard business-critical data.
Learn how solutions like Redgate Monitor, pgNow, Flyway, Redgate Test Data Manager, and pgCompare come together to support everything from monitoring and version control to test data management and schema comparison. Whether you’re scaling PostgreSQL adoption or looking to increase efficiency across your estate, Redgate makes it easier to deliver reliable, high-quality software—faster.
Thursday, September 4 at 13:20 – 14:05
Room: Orangerie
Beyond the Basics: Mastering PostgreSQL Index Performance
Indices are the backbone of efficient data retrieval in PostgreSQL, but their impact on performance is a double-edged sword.
While they accelerate read operations, they can introduce overhead to write operations and consume valuable storage.
This talk delves into the nuances of PostgreSQL index performance, providing practical insights and actionable strategies for optimizing your database.
Whether you’re a seasoned DBA or a developer working with PostgreSQL, this session will equip you with the knowledge and tools to effectively manage indices and maximize the performance of your database tables.
Thursday, September 4 at 11:25 – 12:10
Room: Orangerie
Benchmarking – An unexpected Journey
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.