[PATCH] Add support function for containment operators

2023-04-29 Thread Kim Johan Andersson
I had noticed that performance wasn't great when using the @> or <@ operators when examining if an element is contained in a range. Based on the discussion in [1] I would like to suggest the following changes: This patch attempts to improve the row estimation, as well as opening the possibilit

Re: [PATCH] Add support function for containment operators

2023-11-12 Thread Kim Johan Andersson
. Thanks to Jian for picking this up. Regards, Kim Johan Andersson

Re: [PATCH] Add support function for containment operators

2023-07-06 Thread Kim Johan Andersson
Any thoughts on this change?

Re: [PATCH] Add support function for containment operators

2023-07-07 Thread Kim Johan Andersson
On 07-07-2023 13:20, Laurenz Albe wrote: I wrote: You implement both "SupportRequestIndexCondition" and "SupportRequestSimplify", but when I experimented, the former was never called.  That does not surprise me, since any expression of the shape "expr <@ range constant" can be simplified.  Is th