Make Your SQL Queries 10,000x Faster, for Good
summary
PostgreSQL internals and practical tuning to make SQL queries dramatically faster and stable in production. Covers the database engine’s constraints, which index types to use and when, how optimizer statistics affect execution plans, and the real limits of SQL databases, based on the speaker’s experience managing thousands of PostgreSQL instances.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 1:29DBA role evolution
- 5:01PostgreSQL modular platform
- 7:50Relational databases
- 14:31Performance layers
- 18:19Indexing costs
- 25:56Query planning statistics
- 30:27Advanced PostgreSQL extensions
- 32:34SQL optimization cases
- 38:11Microservice data consistency
- 42:06Performance best practices
- 43:29PostgreSQL resources
related talks
51mPostgreSQL: Practical Examples of SQL Query Optimization
41mOptimizing your app by understanding your PostgreSQL database
48mTricky SQL: Special Features of PostgreSQL's SQL Dialect
24mTop 5 PostgreSQL Query Tuning Tips
23mBest Practices for Tuning Slow Postgres Queries
11mThe Seven Principles for Making a PostgreSQL DB Work Fast
34mSimple and Awesome Database Tricks
46mHow PostgreSQL Can Hurt You When You Least Expect It