Skip to content
Video2Any
Decks extracted with Video2Any

"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021

68 slides Video2Any pulled straight from the conference recording — no upload, all in the browser.

Oleg Ivanov and Yerzhaisang Taskali · FOSDEM 2021, PostgreSQL devroom · video.fosdem.org/2021/D.postgresql/postgres_query_optimization.webm

"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 1
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 2
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 3
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 4
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 5
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 6
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 7
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 8
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 9
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 10
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 11
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 12
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 13
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 14
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 15
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 16
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 17
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 18
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 19
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 20
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 21
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 22
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 23
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 24
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 25
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 26
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 27
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 28
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 29
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 30
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 31
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 32
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 33
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 34
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 35
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 36
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 37
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 38
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 39
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 40
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 41
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 42
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 43
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 44
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 45
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 46
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 47
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 48
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 49
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 50
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 51
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 52
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 53
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 54
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 55
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 56
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 57
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 58
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 59
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 60
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 61
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 62
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 63
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 64
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 65
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 66
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 67
"Adaptive query optimization in PostgreSQL: approaches and challenges" — FOSDEM 2021 — slide 68

Oleg Ivanov and Yerzhaisang Taskali spoke in the PostgreSQL devroom at FOSDEM 2021 on teaching the planner from its own mistakes — feeding real execution times back so the next estimate is closer, with benchmark results for the approach. Video2Any stepped through the 29-minute recording and kept 68 clean frames, one per slide change. Benchmark numbers are the reason to keep a deck rather than a video: a result you might want to quote later is worth having on a page you can search. Every image below is real output, extracted in a browser tab with nothing uploaded.

Slides from FOSDEM, used under CC BY 2.0 BE. Extracted from the original recording (linked above) and credited to FOSDEM; not affiliated with or endorsed by them. Rights concern? request removal.

Private by design

Uploaded files are decoded, compared, and assembled inside your browser tab. They never touch our servers; close the tab and nothing is left behind.

FAQ

Are these the real slides?
Yes — frames from the published recording, one per slide change. FOSDEM publishes its 2021 recordings under CC BY 2.0 BE, which permits reuse with credit; we credit FOSDEM and link the original above.
Can I quote the benchmark figures from these slides?
The numbers are the speakers' own results and citing them means citing the talk, which is linked above. The slides here are the frames themselves, so the figures are pictures of numbers — read them off, and cite the talk.
Can I convert a talk of my own?
Yes, free for your own files. Drop the recording in and Video2Any exports an .pptx or PDF in your browser, with nothing uploaded.

Turn any source type quickly, with no guesswork.

Start converting now

Turn a lecture recording into a study deckConvert MP4 to PowerPoint, right in your browser