aqo
aqo copied to clipboard
postgrespro
Adaptive query optimization for PostgreSQL
In stable 14 and beyond we pretend to use the same query_id in both extensions. Adding AQO TAP-tests on this feature we found out next issues: 1. AQO stores not-parameterized...
[nulls.sql.zip](https://github.com/postgrespro/aqo/files/6033728/nulls.sql.zip)
[explore_query_plan.sql.zip](https://github.com/postgrespro/aqo/files/6031232/explore_query_plan.sql.zip) Index Scan using person_pkey on person (cost=0.29..3226.29 rows=9738 width=8) (actual rows=9738 loops=1) (AQO: cardinality=9738, error=0%, fss hash = -1150030445) SELECT * FROM aqo_data WHERE fsspace_hash=-1150030445; fspace_hash | fsspace_hash |...
[Archive.zip](https://github.com/postgrespro/aqo/files/6028959/Archive.zip)
One of the main aqo problems is the storage (aqo_* relations). Extension writes query and a learn result during (sub)transaction, before and after query execution. It induce some problems: 1....
Change the AQO plan node behaviour: now we add such node also in the case when forced stat gathering option is enabled even in disabled mode. Also: 1. Do not...
I corrected the patch to overlap with the current master version.
Our db have huge amount queries. For some postgres make good plans, for some - bad. I want to use aqo on copy database. After it gather enough data for...
