21. Gulaschprogrammiernacht

Introduction to Postgres Query Planning
06-09, 12:45–13:45 (Europe/Berlin), Blue Saloon
Language: English

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

Content Notes


typescript, python and postgres witch

weird project connoisseur

love finding elegant solutions for weird problems (and the other way around?)