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
1 Billion Row Challenge: Comparing Postgres, DuckDB, and Extensions
at
Postgres Conference 2025
presented by Ryan Booz
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 head-to-head?
In this session, we’ll look at the original c...
more Thu 20 2025 Dev
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
Database DevOps with Flyway Community: Managing Databases as Code
at
Postgres Conference 2025
presented by Ryan Booz
Flyway is a popular open-source tool for managing schema migrations throughout your database and application lifecycle. While getting started with Flyway can be challenging—especially with an existing database and when managed migrations are a new concept—this session will help you succeed.
In this half-day training, we'll explore Database DevOps concepts, including using CI/CD pipelines for...
more Tue 18 2025 Dev
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
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
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
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
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