About this talk
This talk features Alexandra Wang discussing the intricacies of PostgreSQL's query planner and how it can select suboptimal execution plans due to insufficient information. The session explores the mathematics of cardinality estimation and highlights the role of Extended Statistics in providing essential cross-column correlations to enhance estimates. Additionally, the speaker dissects the underlying probability formulas and presents a proof-of-concept focused on improving statistics for joins.
