Uploaded March 2026 | Updated November 2026, 3 hours ago
Talk by Alexandra Wang
socallinuxexpo.org/scale/23x/presentations/helping-planner-help-you-extended-statistics-postgresql
When the PostgreSQL query planner selects a suboptimal plan, the culprit is often missing information. This session examines the mathematics of cardinality estimation, demonstrating how Extended Statistics provide the cross-column correlations needed to improve the estimates. We will dissect the underlying probability formulas and preview a proof-of-concept regarding statistics for joins.
Talk by Alexandra Wang
socallinuxexpo.org/scale/23x/presentations/helping-planner-help-you-extended-statistics-postgresql
When the PostgreSQL query planner selects a suboptimal plan, the culprit is often missing information. This session examines the mathematics of cardinality estimation, demonstrating how Extended Statistics provide the cross-column correlations needed to improve the estimates. We will dissect the underlying probability formulas and preview a proof-of-concept regarding statistics for joins.










