About

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.


Ryan Booz has presented the following presentations

    Ryan Booz Redgate Monitor and pgNow: Actionable PostgreSQL insights for developers and DBAs at Postgres Conference 2025

    presented by Ryan Booz

    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...

    more

    Thu 20 2025 Ops
    Ryan Booz 1 Billion Row Challenge: Comparing Postgres, DuckDB, and Extensions at Postgres Conference 2025

    presented by Ryan Booz

    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...

    more

    Thu 20 2025 Dev
    Ryan Booz Mastering PostgreSQL Partitioning: Supercharge Performance and Simplify Maintenance at Postgres Conference 2025

    presented by Ryan Booz

    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...

    more

    Fri 21 2025 Essentials
    Ryan Booz Query Optimizations and Where to Find Them: A Beginners Guide at Seattle 2024

    presented by Ryan Booz


    video

    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...

    more

    Thu 7 2024 Essentials
    Ryan Booz Mastering PostgreSQL Partitioning: Supercharge Performance and Simplify Maintenance at Seattle 2024

    presented by Ryan Booz


    video

    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 ...

    more

    Wed 6 2024 Essentials
    Ryan Booz Mastering PostgreSQL Partitioning: Supercharge Performance and Simplify Maintenance at Postgres Conference 2024

    presented by Ryan Booz

    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 ...

    more

    Fri 19 2024 Essentials
    Ryan Booz Database DevOps: Options for Test Data and Database Change Management at Postgres Conference 2024

    presented by Ryan Booz

    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...

    more

    Thu 18 2024 Dev
    Ryan Booz 10 Things I Learned Solving Advent of Code Puzzles with PostgreSQL at Silicon Valley 2023
    Using the power of PostgreSQL to investigate complex data

    presented by Ryan Booz

    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...

    more

    Thu 20 2023 Dev