Postgres FM cover image

102 Query optimization

Postgres FM

CHAPTER

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.
App store bannerPlay store banner