Adaptive Query Optimization in PostgreSQL: approaches and challenges
summary
Covers adaptive query optimization to improve PostgreSQL cardinality estimates by using past query execution statistics instead of precomputed histograms. Describes the original k‑nearest neighbors (kNN) based AQO, its applicability limits, and presents a new neural network–based AQO implementation along with initial experimental results.
AI-written summary · about
related talks
40mAdaptive query optimization in PostgreSQL
51mPostgreSQL: Practical Examples of SQL Query Optimization
31mpg_stat_advisor: Optimizing PostgreSQL Planner with Insights
50mImproving Postgres' Efficiency
49mCan PostgreSQL Compete with Analytics Specialists?
35mSmarter Databases in Kubernetes: Applying AI for Query Optimization and Self-Tuning
41mOptimizing your app by understanding your PostgreSQL database
37mRound Table Discussion