Presented by:

Ryanb 512 sqaure

Ryan Booz

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

No video of the event yet, sorry!

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 first tools you can reach for is key when you’re called on to help.

In this session, we’ll open up the beginners toolbox and look at the primary settings, indexes, tools, features, and SQL tips to explore first. Starting with the basics of EXPLAIN plans, ad hoc settings to improve specific queries, indexes, partitioning, and a few SQL tips, you’ll walk away with a number of ideas to explore as you run up against unexpected issues in the day-to-day life of your PostgreSQL application.

Date:
2024 November 7 14:30 PST
Duration:
50 min
Room:
Essentials: 420
Conference:
Seattle 2024
Language:
Track:
Essentials
Difficulty:
Easy