![SQL query optimization: a comprehensive developer's guide illustration](https://cdn.sanity.io/images/sczeoy4w/production/bbe8816829690721b1670cfc73e2a8072bbe0b1b-2500x1308.png?q=80&fit=min&auto=format&dpr=1.5)
Developer Center
An SQL optimization guide for developers. With best practices, warnings, and pro tips to speed up your SQL query optimization.
In this online workshop you'll learn the basics of query optimization in PostgreSQL®. From understanding the path of the query to optimizing your indexes and joins, we’ll cover the foundation, tools and techniques to improve the performance of your SQL queries.
This workshop is one hour long. Open to beginner levels, though the knowledge of SQL basics is desired.
SQL optimization is essential for efficient database management, especially when dealing with complex queries and large datasets. In this workshop, you'll familiarize with the fundamentals of SQL optimization with a focus on PostgreSQL®. This hands-on session will guide you through key techniques and best practices to enhance the performance of your SQL queries.
We'll look at how PostgreSQL processes queries, helping you spot any bottlenecks and areas that need improvement. You'll learn how to use indexes effectively to speed up your queries without overdoing it. We'll also explore the best ways to use joins in your queries, when to use them for the best performance.
We'll discuss how PostgreSQL handles data changes, what table bloat is, and why regular vacuuming is crucial for keeping your database in good shape. Plus, we’ll show the usage of AI tools to identify and troubleshoot common query performance issues using practical examples.
You'll get plenty of hands-on experience. It's going to be a fun and informative session, so don't miss out!
In this workshop, we’ll cover the following topics:
Senior Developer Advocate, Aiven
Olena is an expert in data, sustainable software development, and teamwork. With a background in software engineering, she's led teams and developed mission-critical applications at Nokia, HERE Technologies, and AWS. Currently, she works at Aiven where she supports developers and customers in using open-source data technologies such as Apache Kafka, ClickHouse, and OpenSearch. She is also an international public speaker and regularly presents at conferences around the world. She holds AWS Developer and Solutions Architect certifications, and is also a Confluent Catalyst.
Live and interactive sessions to upgrade your skills with expert guidance covering a range of open source technologies.
Explore all workshopsDeveloper Center
An SQL optimization guide for developers. With best practices, warnings, and pro tips to speed up your SQL query optimization.
Developer Center
Learn the theory and the details of how to speed up PostgreSQL® pgvector queries using indexes IVFFlat, HNSW and traditional indexes
Blog
Increase database performance by 10x with an expert, AI-driven, professional available 24/7.