List of videos

A series of short talks, each a maximum of 5 minutes long, submitted by attendees and selected during the conference itself. Hosted by Dave Page, but all the good stuff comes from our awesome speakers: Christoph Berg: Bits and News from the PostgreSQL Contributors Team Di Qi: A Simple Version of BM25 in Postgres Mark Wong: PostgreSQL Performance Farm 5 Second Update Neeta Goel: Migration Consideration: Oracle to PostgreSQL Enes Cakir: Reduce your GitHub Actions bill by 10x Jelte Fennema-Nio: pg_duckdb: Challenges and Benefits of Elephants with Beaks Hannu Krosing: PgObject - a self-describing pg-typed structured data type (like JSON but Much Better) Raoul De Guchteneere: Migrating on new servers using repmgr with near zero downtime Chris Ellis: So, You Want A … PGDay Website? Marat Bogatyrev: From Backup to Integrity. Leveraging WAL-G for PostgreSQL Ads & Floor: Every Postgres contribution counts Eren Basak: Managing PostgreSQL on Cloud Claire Giordano: My Journey to PostgreSQL & the PGCA Board of Directors

PostgreSQL is gaining popularity every day, but what does it really mean to run PostgreSQL in the real world? How does it impact an insurance company, a startup, a personal project, or research endeavors? More importantly, how can we leverage Open Source to improve life for everyone? Which contributions truly make a difference and have a lasting impact?

What does it take to make Postgres serverless? What were the difficulties, what has worked well. What we working on, and what are we looking forward to, to make Postgres great for modern serverless cloud environments.

You are the devops mastermind behind your application, sending a lot of queries happily to your database, which just as happily answers your requests. But suddenly BOOOM, your application is getting slow. Wait, that must be the database, right? If there is a database expert in your organization, you are sending them an SOS. There are chances they will ask you a myriad of questions, so that they can identify the problem faster. If you don't have anyone to ask, you have to ask yourself - but what exactly? And how to answer all those questions? Even more importantly, how do you get to the solution - as fast as possible? This talk presents an approach with which such problems can be approached in a structured manner, helping both developers/devopses and database people troubleshoot database performance problems.

The rise of operators like CloudNativePG is transforming Postgres deployments in Kubernetes, providing flexibility for running databases across VMs or bare metal, with dedicated storage for high-performance needs. This open source stack—combining Kubernetes, Postgres, and CloudNativePG—also aligns with the European Union's Data Act, which requires service providers to guarantee data portability and facilitate switching between vendors. EDB Technical Fellow and Advisor Dr. Marc Linster, Ph.D. will join Gabriele on stage for this talk to explore how organizations are evolving the way they run Postgres databases in Kubernetes—leveraging CloudNativePG, the open source and openly governed operator founded by EDB. We will also highlight the opportunities this shift presents for PostgreSQL DBAs to participate in this evolutionary change and retain full control of their data again, including on-premises.

This talk will examine how to cause damage to a PostgreSQL database by abusing insecure configuration or object definitions: impair availability (denial of service) gain access to the database gain access to forbidden data become superuser You need to know the dangers if you want to protect your database!

Extensions are the powerups of the PostgreSQL database, they can add new datatypes, indexing methods and even turn a single PostgreSQL instance into a horizontal distributed system. At the same time, some extensions may be incompatible, can introduce risks to the stability of the database, integrity of data it holds and the overall security of your deployment. We will go over these concepts and you will learn how we approach reviewing both our extensions and open-source extensions before onboarding them to the Azure cloud service. You will be able to apply a similar process to your local and cloud environments.

[Sponsor Track] Bilge Ince - Integrating AI with Postgres: Opportunities, Challenges, and Future Possibilities

Neon's storage system is like a WAL archive on steroids. It makes it possible to retrieve database pages at any point in time, which makes fast startups and branching possible. I will demonstrate how to do time travel, and talk about the technology behind it.