AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
Introduction
The hosts delve into the topic of row estimates in Postgres query planner and how inaccurate estimates can lead to performance issues. They discuss how Postgres makes decisions based on these estimates and provide tips for users to improve statistics and guide the planner, while comparing the trade-offs of using nested loops versus other join algorithms.