Video

If you are a newcomer to PostgreSQL or want to be more active within the community you need to understand how the community works, what different roles are, where to look for help and who stands behind the “PostgreSQL community”. Valeria's talk contains references to other talks, guides and materials so it can serve as a toolbox for anyone who is looking to join and contribute to further develo...

Claire Giordano: Fighting the Butterflies & giving your first Postgres conference talk Léo Unbekandt: Deploying thousands of PostgreSQL Clusters - High-Level Architecture of a DBaaS Karen Jex: You Don't Need a Database Backup Policy Chris Ellis: Electric Elephants Matt Cornillon: Discover your favorite cheeses using Postgres and AI Michael Christofides: BUFFERS by default Floor Drees: That's a ...

The idea of predicting how the database is going to behave under certain conditions is very attractive. In this talk, Dmitry goes beyond science fiction to discuss possible approaches for modelling, taking a simplified PostgreSQL index under a load as an example and tries to simulate and verify the resulting IO profile.

Dirk talks about the PostgreSQL extension PG_PROFILE, including requirements and basic setup. He shows with examples and practical experiences how this can be used for proceeding performance analytics.

In this talk, Matthias discusses the technical challenges they encountered at Neon while building a disaggregated storage and compute project based on a PostgreSQL fork: the problems that they encountered, the solutions they built for them, and the benefits they get from disaggregating storage and compute.

In this presentation, Pierre gives an introduction to what multi-tenant databases are, how they can be implemented, and how they can come back haunt you.

The PostgreSQL community has made this technology the most relevant database in the world. As a database known for its rapid innovation and constant growth, the future is always top of mind for those who build on Postgres. The world is now amidst a profound technological shift. The best companies are digitally transforming 2.5 times faster than their competitors. The race is on to deliver a uni...

Hacking PostgreSQL can be challenging for newcomers. This presentation covers a set of tips that have accumulated in my development environment when it comes to do something, basically anything, with the core PostgreSQL engine. From the environment used to more internal must-haves, this presentation can be helpful for newcomers, more advanced users, as well as maintainers of extensions or forks...

pgBadger stands as one of the most comprehensive and widely adopted tools for diagnosing issues and analyzing the current state of a PostgreSQL database. As an open-source utility that's platform-agnostic and easy to use, it offers users in-depth insights into a myriad of events occurring within their databases. This includes visibility into the activities of the autovacuum daemon, such as the ...

I started a thread on pgsql-hackers "Let's make PostgreSQL multi-threaded" in June. That spurred a lot of discussion, which even made it to LWN and hacker news. There is little code to show, but I will paint a picture of what it would look like: - Multithreading vs multi-process architectures in general - Pros and cons - How exactly multiple threads could be used - Hybrid approaches - Previous ...

Learn how to tame the growth of your database by understanding copy-on-write and HOT updates. PostgreSQL MVCC model is based on copy-on-write semantics. To avoid write amplification on updates PostgreSQL implements a HOT-update optimization. In this talk I will go over how copy-on-write works, how HOT updates work and how you can accidentally shoot yourself in the foot by depriving the database...

We all know that Postgres is a popular database for many different applications. Developers love the fact that Postgres "just works" out of the box. On the other hand, the default parameter values aren't always right for production, and you might not have a DBA on hand to configure them for you. Fortunately, you don't need to learn about all 350 Postgres parameters to get the most out of your d...

Andreas Scherbaum: Add geocoordinates to your addresses in PostgreSQL (PGConf.EU 2023)

Daniel Westermann: Getting the most out of pg_stat_io (PGConf.EU 2023)

Andres Freund: The path to using AIO in postgres (PGConf.EU 2023)

Melanie Plageman: Making your patch more committable (PGConf.EU 2023)

Peter Eisentraut: pg_failover_slots: The missing piece (PGConf.EU 2023)

Rajiv Harlalka: Charting My Path: Journey of a GSoC 2023 Contributor to PostgreSQL with pg_statviz

Alexander Sosna: How we execute PG major upgrades at GitLab, with zero downtime. (PGConf.EU 2023)

Let’s talk about what it’s like for women in tech! Taking inspiration from the most popular movie of 2023, Barbie, we unravel the challenging journey of women navigating a male-dominated tech world. In this engaging discussion, we share poignant stories that highlight both subtle and overt instances of gender bias, offering valuable insights into the persistent hurdles that women encounter. By ...

This is the second addition of performance tricks one has never seen before. Let us take a look at some of the hidden trickery a PostgreSQL consultant can use to make life better. Everything from indexes to storage to query tuning to other tricks. In this talk there will be wisdom which is passed on from "PostgreSQL druid to PostgreSQL druid" only.

Julian Markwort: PostgreSQL Replication: 20 Pitfalls and Solutions (PGConf.EU 2023)

Ophir Lojkine: SQLPage - Building a full web application with nothing but Postgres and SQL queries

Akshat Jaimini: Making pgweb rock-solid: Using the Testing Harness to ensure the quality of pgweb

Marco Slot: PostgreSQL Distributed: Architectures & Best practices (PGConf.EU 2023)

Laurenz Albe: How to corrupt your database (and how to deal with data corruption) (PGConf.EU 2023)

Ilya Kosmodemiansky: Linux IO internals for PostgreSQL administrators in 2023 (PGConf.EU 2023)

Stephen Frost: Advanced Authentication and Encrypted Connections (PGConf.EU 2023)

Greg Vernon: Don't Do High Availability, Do Right Availability (PGConf.EU 2023)