Re: Inquiry/Help with pg_adviser (problem in index_create function for creating indexes)

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)