
102 Query optimization
Postgres FM
Discussion on Extreme Indexing Failure Cases and Query Optimization
This chapter delves into the two extreme failure cases of adding indexes in a database: not having enough indexes, leading to scalability issues, and having too many indexes, resulting in inefficient performance and increased costs. The hosts stress the importance of understanding your workload, experimenting with query optimization, and highlight the significance of optimizing for buffers to reduce costs.
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.