Ryan Booz
PostgreSQL Advocate at Redgate Software
Ryan is an Advocate at Redgate focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA and product manager for more than 22 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.
Ryan is a long-time DBA, starting with MySQL and Postgres in the late 90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He’s at the top of his game when he's learning something new about the data platform or teaching others about the technology he loves.
Upcoming presentations
No upcoming presentations...
Past presentations
Monitoring PostgreSQL can be a challenge, especially when things are on fire and you're not sure exactly where to start. Having the right tools at your fingertips that can gather metrics, queries, and logs is essential to efficiently managing your application databases.
In this session we'll review the main areas to focus on to effectively monitor PostgreSQL and how two tools from Redgate ca...
Mar 20 2025
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. Postgres, in many cases, performed the worst without close attention to settings and efficient resource utilization. But, with a little more effort, could it compete h...
Mar 20 2025
As your database grows, the performance and maintenance of large tables can become challenging. Fear not! PostgreSQL has the right tool for the job: declarative table partitioning. This talk will discuss the benefits of partitioning in PostgreSQL, including improved performance and simplified maintenance.
After introducing the benefits of table partitioning, we’ll take a whirlwind tour throu...
Mar 21 2025
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. And although it may surprise you in 2024, improving problem queries still requires human intervention in many cases. Knowing where to begin and some of the fi...
As your database grows, the performance and maintenance of large tables can become challenging. Fear not! PostgreSQL has the right tool for the job: declarative table partitioning. In this talk, I will explore the benefits of partitioning in PostgreSQL, including improved performance and simplified maintenance.
After introducing the benefits of table partitioning, I’ll discuss the different ...
As your database grows, the performance and maintenance of large tables can become challenging. Fear not! PostgreSQL has the right tool for the job: declarative table partitioning. In this talk, I will explore the benefits of partitioning in PostgreSQL, including improved performance and simplified maintenance.
After introducing the benefits of table partitioning, I’ll discuss the different ...
Apr 19 2024
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.
Managing migrations with your ORM of choice is easy but often highly manual, error-prone and hard to manage as the project grows. Or worse yet, maybe your schema and change management consists of poorly commented SQL scripts sav...
Apr 18 2024
10 Things I Learned Solving Advent of Code Puzzles with PostgreSQL
Using the power of PostgreSQL to investigate complex data
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. I decided to join them, knowing it would challenge my skills, knowledge, and understanding of the dat...
Apr 20 2023