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 20 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
Query Optimizations and Where to Find Them: A Beginners Guide
at
Seattle 2024
presented by Ryan Booz
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
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