On 8/7/22 19:28, Tom Lane wrote:
> Tomas Vondra writes:
>> Yeah, this seems like a clear bug - we should not fail queries like
>> this. It's a sign statext_is_compatible_clause() and the MCV code
>> disagrees which clauses are compatible.
>
> Indeed. I attempted to fix that at e33ae53dd.
>
Tomas Vondra writes:
> Yeah, this seems like a clear bug - we should not fail queries like
> this. It's a sign statext_is_compatible_clause() and the MCV code
> disagrees which clauses are compatible.
Indeed. I attempted to fix that at e33ae53dd.
regards, tom lane
On 8/5/22 11:50, Danny Shemesh wrote:
> Hey all !
>
> I'm on a quest to help the planner (on pg14) use the best of several
> partial, expressional indices we have on some large tables (few TBs in
> size, billions of records).
>
> As we know, stats for expressions in partial indices aren't
Hey all !
I'm on a quest to help the planner (on pg14) use the best of several
partial, expressional indices we have on some large tables (few TBs in
size, billions of records).
As we know, stats for expressions in partial indices aren't gathered by
default - so I'm tinkering with expressional