On 25/06/2023 17:30, Ahmed Ibrahim wrote:
The full current code (PR is still draft) can be found at
https://github.com/DrPostgres/pg_adviser/pull/4
<https://github.com/DrPostgres/pg_adviser/pull/4>
The idea behind what is being done is creating virtual indexes, and
measuring the query cost after creating those indexes, and see whether
we will get a better cost or not, and maximize the benefit from those
choices.
So far, the project is okay and compiling/working successfully (with
Postgres 16), but the problem is when creating
the virtual indexes (with version 16), I give it flag
/INDEX_CREATE_SKIP_BUILD/ (just like it was with version 8.3 and was
working)
https://github.com/HypoPG/hypopg might be of interest to you. It also
creates virtual or "hypothetical" indexes.
--
Heikki Linnakangas
Neon (https://neon.tech)
