Ryan Booz

This half-day working session brings together practitioners, builders, and skeptics to explore how AI, machine learning, and automation are reshaping the way we develop, run, and scale PostgreSQL. Through a curated set of short talks and an interactive discussion, we will move beyond hype and focus on: This is not a passive session.

You can write a SELECT statement, but do you know your way around Postgres itself? This session is a fast, live-demo tour built for people who know SQL but are newer to Postgres specifically.

Nobody wakes up one day knowing how to safely back up a Postgres database, plan a version upgrade, or explain why they need a connection pooler. It's usually learned the hard way, mid-incident.

Something's wrong with your Postgres database; a query is stuck, the app is timing out, or it's just "slow" and nobody can say why. This session is the diagnostic toolkit for exactly that moment.

Postgres offers many tools for query observability, but many teams struggle to use them effectively. Some collect too little data and miss important performance problems, while others log everything—creating noise, overhead, and confusion without clear next steps.

PostgreSQL partitioning continues to gain popularity and adoption. While many users understand the basics of creating partitions, they often seek practical guidance about their pros and cons, ideal use cases, and potential pitfalls.

After getting into beekeeping a few years ago, I expected to get stung a lot and eat some natural, raw honey. What I didn’t expect was how much the structure of a healthy hive mirrors the challenges we face in our work and personal lives.

In late 2023, the Java community started a challenge to find the most efficient way to process a file with 1 billion rows of data. Unsurprisingly, many database communities quickly took on the same challenge with varying results.

With the power of PostgreSQL, modern data transformation can happen inside the database rather than with external tools. This is known as the extract, load, and transform (ELT) pattern using built-in functions and SQL features to work with data regardless of the form.

Creating consistently fast, efficient queries and applications requires effort. Regardless of improvements to hardware, query planning, data storage, and all things AI, users generally only care about one metric; how fast queries respond.

Managing database schema changes in a DevOps culture can be a daunting task. Having a process in place that provides for quick, predictable iterations across a team of developers and DBAs can accelerate your ability to deliver value to customers.

Managing database schema changes in a DevOps culture can be a daunting task. Having a process in place that provides for quick, predictable iterations across a team of developers and DBAs can accelerate your ability to deliver value to customers.

Whether you are the DBA for an agile, sprint-based team, or a developer with DBA responsibilities, you may feel like there are development bottlenecks at every turn.

Security is an essential, yet often misunderstood, part of effectively managing a PostgreSQL cluster. As the popularity and adoption of PostgreSQL continues to grow, the interaction of roles, privileges, and object ownership is a recurring theme of confusion in forums and mailing lists.

Whether you are the DBA for an Agile, Sprint-based team, or a developer with DBA responsibilities, you may feel like the development bottleneck at every turn. Managing migrations with your ORM of choice is easy but often error-prone, slow and hard to manage as the project grows.

As the popularity of PostgreSQL continues to soar, many companies are exploring ways of migrating their application database over. At Redgate Software, we recently added PostgreSQL as an optional data store for SQL Monitor, our flagship monitoring application, after nearly 18 years of being backed exclusively by SQL Server.

PostgreSQL can be difficult to troubleshoot when the pressure is on without the right knowledge and tools. Knowing where to find the information you need to improve performance is central to your ability to act quickly and solve problems.

Since December 2015, Eric Wastl has been creating 25 daily coding puzzles each year known as The Advent of Code. In 2022, more than 250,000 developers from around the world worked each day to solve the challenges in a language of their choice, including some members of the PostgreSQL community.

Arrays are an essential part of software development. Among modern databases, however, only PostgreSQL has dedicated datatypes, functions, and indexes built to efficiently work with arrays.

In a world where data continues to grow at an overwhelming rate, knowing how to load and insert data into PostgreSQL as efficiently as possible is a key skill for any software or data engineer.

Since December 2015, Eric Wastl has been creating 25 daily coding puzzles each year known as The Advent of Code. In 2022, more than 250,000 developers from around the world worked each day to solve the challenges in a language of their choice, including some members of the PostgreSQL community.

In a world where data continues to grow at an overwhelming rate, knowing how to load and insert data into PostgreSQL as efficiently as possible is a key skill for any software or data engineer. Whether loading data from files, manually generating multi-valued INSERT or UPSERT statements, or using some of the more popular language SDKs, knowing which option is right for each situation can…

In a world where data continues to grow at an overwhelming rate, knowing how to load and insert data into PostgreSQL as efficiently as possible is a key skill for any software or data engineer.

The third annual State of Postgres survey was completed in June of this year. With more than 1,000 responses this year, we are excited to see such enthusiastic participation from the Postgres community.

Exploring new features in PostgreSQL or reproducing an unusual query plan can be tricky without representative data to utilize. While there are a plethora of sources for sample data and tools to import it, you can end up spending too much time finding representative data to work with.

Whether you are the PostgreSQL DBA for an Agile, Sprint-based team, or a Developer with DBA responsibilities, you may feel like the development bottleneck at every turn. Managing migrations with your ORM of choice is easy but often error-prone and hard to manage as the project grows.