Helping the Planner Help You: Extended Statistics in PostgreSQL @socallinuxexpo
Helping the Planner Help You: Extended Statistics in PostgreSQL  @socallinuxexpo
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.
Helping the Planner Help You: Extended Statistics in PostgreSQLFive Stages Of Grieving-Databases in Infrastructure as CodeWarp, Weft, and Code: Textiles as the Hidden Foundation of ComputationBrand Building in Open Source: Why It MattersCindy Cohn: Privacy’s Defender - Fighting Digital Surveillance for over Thirty YearsInfrastructure-as-Code for rapid FreePBX deploymentsThe Ralph Wiggum Loop: How Autonomous AI Loops Built My Serverless SaaS While I SleptOperating Postgres Logical Replication at Massive ScaleNixOS on the NVIDIA DGX SparkUnder the Hood: Deep Dive into Asterisk PerformanceVitess for Newbies: Scaling MySQL the YouTube WayDo You Need An AI Assistant With MySQL?
Southern California Linux Expo |

Helping the Planner Help You: Extended Statistics in PostgreSQL

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER