AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
5min chapter
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
Episode notes
Get the Snipd
podcast app
Unlock the knowledge in podcasts with the podcast player of the future.
AI-powered
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode
Save any
moment
Hear something you like? Tap your headphones to save it with AI-generated key takeaways
Share
& Export
Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more
AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
Discover
highlights
Listen to the best highlights from the podcasts you love and dive into the full episode