Postgres FM 102 Query optimization
Oct 7, 2022
The podcast discusses query optimization in PostgreSQL, including steps involved, testing in a similar setup as production, analyzing the impact of sampling and bloat, optimizing queries' impact on other queries, and extreme indexing failure cases.
Chapters
Transcript
Episode notes
1 2 3 4 5
Introduction
00:00 • 2min
Testing in a Similar Setup as Production
01:51 • 4min
Analyzing the Impact of Sampling and Bloat on Query Optimization
06:12 • 2min
Query Optimization and its Impact on Other Queries
07:46 • 19min
Discussion on Extreme Indexing Failure Cases and Query Optimization
26:19 • 5min