On 28/2/2024 17:27, Alena Rybakina wrote: > Maybe like that: > > It also considers the way to generate a path using BitmapScan indexes, > converting the transformed expression into expressions separated by "OR" > operations, and if it turns out to be the best and finally selects the > best one. Thanks, I spent some time describing the feature with documentation. A condensed description of the GUC is in the runtime-config file. Feature description has spread between TransformOrExprToANY and generate_saop_pathlist routines. Also, I've made tiny changes in the code to look more smoothly. All modifications are integrated into the two new patches.
Feel free to add, change or totally rewrite these changes.
I'm going to review and revise the patch.
One question I have yet.
> /* > * Transformation only works with both side type is not > * { array | composite | domain | record }.
Why do we limit transformation for these types? Also, it doesn't seem the current code restricts anything except composite/record.