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)