Creating fast, efficient queries and applications requires effort. Despite ongoing improvements in hardware, query planning, data storage, and AI, users care about one thing above all—how quickly queries respond. Even in 2024, improving problematic queries often requires human expertise. When called upon to help, knowing where to begin and which tools to reach for first is crucial.

In this session, we'll explore the beginner's toolbox of primary settings, indexes, tools, features, and SQL tips. Starting with EXPLAIN plans, we'll cover ad hoc settings for query improvement, indexing strategies, partitioning, and essential SQL techniques. You'll leave with practical ideas to tackle unexpected issues in your day-to-day PostgreSQL application management.