aqo
A PostgreSQL extension that uses machine learning to improve query cardinality estimation and optimize execution plans.
What is aqo?
AQO (Adaptive Query Optimization) is a PostgreSQL extension that enhances the standard cost-based query optimizer by using machine learning models to improve cardinality estimation based on actual query execution statistics. It solves the problem of poor query performance caused by inaccurate cardinality estimates in complex queries, which can lead to suboptimal execution plans. The extension continuously learns from workload patterns to make PostgreSQL query planning more adaptive and intelligent.
Database administrators and developers working with PostgreSQL who are experiencing slow query performance due to inaccurate cardinality estimates, particularly for complex analytical or join-heavy queries. It's especially relevant for those managing production databases where query optimization is critical.
Developers choose AQO over standard PostgreSQL optimization because it provides adaptive learning that continuously improves cardinality estimates based on actual execution data, leading to significant performance gains for problematic queries. Its unique selling point is the ability to automatically tune optimization settings per query type while offering multiple operation modes that balance automation with manual control.
Overview
Adaptive query optimization for PostgreSQL
Use Cases
Best For
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
