Room: Orangerie

Thursday, September 4 at 18:10 – 19:30

Room: Orangerie

Networking/Get Together time

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

Past, Present, and Future: Logical Decoding and Replication in PostgreSQL

Logical replication has evolved into a foundational capability for modern PostgreSQL deployments, enabling real-time data synchronization, partial replication. What began as a low-level decoding API in PostgreSQL 9.4 has now matured into a powerful feature, allowing for fine-grained control over what gets replicated and where.

In this talk, we’ll trace the journey of logical decoding and replication in PostgreSQL, from its early adoption through extensions like pglogical, to the robust native features introduced in recent PostgreSQL releases. We’ll dive into how these capabilities have empowered change data capture (CDC), zero-downtime migrations, and real-time analytics pipelines.

We’ll also explore how innovations in the ecosystem, particularly the work of pgEdge Spock and AWS pgactive are shaping the future of distributed PostgreSQL.

Key takeaways:
– Understand the architecture and internals of logical decoding
– Compare native and extension-based logical replication
– Discover what’s next: DDL replication, performance tuning, and multi-master replication
– Learn how extensions from pgEdge and AWS are extending PostgreSQL for a globally distributed, logically replicated future

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.