Andrei Lepikhov

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)

AQO service storage problems

1

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...

Hi, In my environment (MacOS) a warning generates at each compilation (see subj). I am not the best in java, so, could You fix this issue, just to avoid setting...

thanks for your efforts, As I see, you use query string comparisons as a criteria that the stored plan matches incoming query. I think it is a bad idea. Do...

I tried to use the extension in the MacOS Ventura 13.5 and found some issues: 1. User can't compile it as a part of the contrib - you provide the...