Postgres FM Row estimates
Dec 23, 2022
The podcast discusses the importance of row estimates in Postgres query planner. Topics include join strategies, auto vacuum, optimizing row estimates and statistics target, the problem of row estimates, and materialized views, indexes, and hints.
Chapters
Transcript
Episode notes
1 2 3 4 5 6
Introduction
00:00 • 3min
Discussion on Join Strategies and Analyzing Statistics
02:37 • 2min
Auto Vacuum in Postgres
04:30 • 9min
Optimizing Row Estimates and Statistics Target in PostgreSQL
13:05 • 10min
The Problem of Row Estimates in Postgres
23:32 • 5min
Discussion on Materialized Views, Indexes, and Hints
28:39 • 3min