performance
Workshop (half-day)
PostgreSQL Query Optimization: How to Write Efficient Queries
Would you like to write queries that perform fast and deliver results on time? During this workshop, you will learn that query optimization is not a dark art practiced by a small group of sorcerers. Any motivated professional can learn to write efficient queries from the get-go and capably optimize existing queries. You will learn to look at the process of writing a query from the database engine’s point of view and know how to think like the database optimizer.
Upon workshop completion, the participants will learn to:
- Identify optimization goals in OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) systems
- Read and understand PostgreSQL execution plans
- Identify indexes that will improve query performance
- Optimize full table scans
- Distinguish between long queries and short queries
- Choose the correct optimization technique for each query type
- We will conclude the workshop by presenting the Ultimate Optimization Algorithm