102 Query optimization
Postgres FM
00:00
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.
Transcript
Play full episode
