Share
))
This is the audio podcast version of Troy Hunt's weekly update video published here: https://www.troyhunt.com/tag/weekly-update/
…
continue reading
Introduction to Postgres Query Planning (gpn21)
Manage episode 365659785 series 2475293
Content provided by CCC media team. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by CCC media team or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://cloudutil.player.fm/legal.
**How do databases get from SQL query to result? How do they do it *quickly*?** In this talk, we'll discuss how to represent queries as trees, look at some basics of query optimization and look into the Postgres query planner specifically. With some examples, we'll see how it uses statistics, estimates costs and ultimately decides on an execution plan. We'll open the hood, read some query plans, see what can go wrong and talk about approaches for helping the planner out. Slides: https://leftshift.github.io/query-planner-talk about this event: https://cfp.gulas.ch/gpn21/talk/GUTJAD/
…
continue reading
1662 episodes
