PostgreSQL: Practical Examples of SQL Query Optimization
summary
Practical techniques for finding and fixing SQL query bottlenecks in PostgreSQL are presented, focusing on how to analyze where performance problems occur and how to optimize queries rather than just tuning the DBMS or OS. The talk covers concrete examples and approaches for developers and DBAs to identify hotspots and avoid common slow-query patterns in PostgreSQL.
AI-written summary · about
chapters (16)
- 0:00Query optimization intro
- 1:16Effective query definition
- 4:24Query execution stages
- 8:39Database design
- 12:58Data types and indexes
- 16:29B-tree indexes and covering
- 23:02Index covering and visibility map
- 26:14Index covering example
- 29:01Materialized View
- 30:29Table join methods
- 36:54Nested Loop vs Hash Join
- 38:03Full Join and statistics
- 41:14Hints and functions
- 43:45Common client issues
- 48:45Query mistakes and LIMIT OFF
- 50:08Summary and advice
related talks
45mMake Your SQL Queries 10,000x Faster, for Good
24mTop 5 PostgreSQL Query Tuning Tips
23mBest Practices for Tuning Slow Postgres Queries
41mOptimizing your app by understanding your PostgreSQL database
48mTricky SQL: Special Features of PostgreSQL's SQL Dialect
46mHow PostgreSQL Can Hurt You When You Least Expect It
11mThe Seven Principles for Making a PostgreSQL DB Work Fast
42mPostgreSQL Tips & Tricks For App Devs