{"repo":"postgrespro/aqo","free":true,"listed":false,"github":"https://github.com/postgrespro/aqo","clone":"git clone https://github.com/postgrespro/aqo.git","description":"Adaptive query optimization for PostgreSQL","language":"C","stars":499,"topics":["postgresql","query-optimizer","adaptive","optimization"],"license":"AGPL-3.0","category":"databases-storage","readme_excerpt":"Adaptive query optimization Adaptive query optimization is the extension of standard PostgreSQL cost-based query optimizer. Its basic principle is to use query execution statistics for improving cardinality estimation. Experimental evaluation shows that this improvement sometimes provides an enormously large speed-up for rather complicated queries. Installation The module works with PostgreSQL 9.6 and above. To avoid compatibility issues, the following branches in the git-repository are allocated: stable9 6 . stable11 - for PG v10 and v11. stable12 - for PG v12. stable13 - for PG v13. stable14 - for PG v14. stable15 - for PG v15. the master branch of the AQO repository correctly works with PGv15 and the PostgreSQL master branch. The module contains a patch and an extension. Patch has to be applied to the sources of PostgresSQL. Patch affects header files, that is why PostgreSQL must be rebuilt completely after applying the patch ( make clean and make install ). Extension has to be unpacked into contrib directory and then to be compiled and installed with make install . Tag version at the patch name corresponds to suitable PostgreSQL release. For PostgreSQL 9.6 use the 'aqo pg9 6.patch' file; PostgreSQL 10 use aqo pg10.patch; for PostgreSQL 11 use aqo pg11.patch and so on. Also, you can see git tags at the master branch for more accurate definition of suitable PostgreSQL version. In your database: CREATE EXTENSION aqo; Modify your postgresql.conf: shared preload libraries = 'a","default_branch":null,"files":null,"tree":[],"storefront":"/r/postgrespro","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/postgrespro/aqo/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}